An open community 
of Macintosh users,
for Macintosh users.

FineTunedMac Dashboard widget now available! Download Here

Previous Thread
Next Thread
Print Thread
Filemaker on two workstations w/ shared DB
#11227 07/31/10 05:58 PM
Joined: Aug 2009
OP Offline

Joined: Aug 2009
I am helping a small company with two networked computers and no server be able to share and update a single Filemaker database simultaneously without buying the Server Edition, which they tell me is $1,000 regardless of how many users. I thought maybe someone would know this one offhand.

I networked my Macbook Pro running Snow Leopard and my Titanium running Panther. I have Filemaker 8.5 which I bought for the Ti because it never ran Tiger very well and Filemaker is nice in the fact that they offer a free upgrade to 8.5v2 that allows it to run under SL.

I got a DB to show up and be editable on both computers but the edits on one were not reflected on the other which rendered the whole setup useless. Is purchasing the server edition the only solution? Like a lot of other programs, I only know Filemaker well enough to do the things I have to do.

They are running Leopard on both computers and Filemaker 11. Does that make any difference? It is very disruptive to their workflow to do all kinds of experimenting there.

Any help is deeply appreciated.

Slo


Mid 2010 MacBook Pro 13"
2.4GHz, 750GB SATA HD, 8 GB RAM, OS 10.7.5
1 HDX1500 2TB Ext.HD, 2 HDX1500 1TB Ext.HD
HP Laserjet 6MP printing postscript via 10/100 Intel print server
Netgear WN2500RP Range Extender (Ira rocks!)
Linksys WRT1900AC Wireless Router
Brother MFC-9340CDW Color Laser
iPad Air
Re: Filemaker on two workstations w/ shared DB
slolerner #11242 08/01/10 04:43 AM
Joined: Aug 2009
Offline

Joined: Aug 2009
they want their G. you're not likely to get away from that.


I work for the Department of Redundancy Department
Re: Filemaker on two workstations w/ shared DB
slolerner #11248 08/01/10 05:10 AM
Joined: Aug 2009
Likes: 1
Offline

Joined: Aug 2009
Likes: 1
Yep, you need the server version.

Creating a shared database such that multiple clients all automatically update when the database updates is a nontrivial thing to do, hence the cost.


Photo gallery, all about me, and more: www.xeromag.com/franklin.html
Re: Filemaker on two workstations w/ shared DB
tacit #11360 08/06/10 08:48 AM
Joined: Sep 2009
Offline

Joined: Sep 2009
I'm afraid that's not true, tacit. You can open a single FileMaker database residing on one machine and access it from another.

You need to have different serial numbered copies of FileMaker Pro on the host machine (where the FileMaker Pro data file is located), and on any machines that want to access/modify the data. You don't directly open the data file on the client machine. Rather, you use File>Open Remote...

You need to have Sharing enabled for the host machine's copy of FileMaker Pro, and to have identified the file(s) to be shared, and who is allowed to access it/them. (File>FileMaker Network...)

This will even work over the internet if the correct port redirection has been set up in your broadband router.

You can even modify the database deign this way.

Of course, many things work much more efficiently using FileMaker Server to host the file. For example, With FileMaker Server, searches and sorts are done on the host, but the search or sort needs to be done on the client otherwise which makes for a lot of additional network/internet traffic.

To access a database on a client machine, choose File>Open Remote...
Of course, the database must be already open on the host machine.

Think of this as database sharing rather than file sharing. File sharing does not even have to be enabled.

A couple of other points:
1. I often create a "opener" file on the client machine, which is an empty database - no tables defined, no data - which has a script that executes on opening that opens the real file remotely, and then closes itself. That way the user at the client machine has no need to know how to open it remotely - I just put something called "Start Database" or some such in the dock.

2. FileMaker Server has provision for automatic timed backups, which is not available using this peer-peer database sharing. What I often do is write a script that makes a duplicate copy of the database automatically on opening or closing. While a database file that is open will not backup reliable in Time Machine, the duplicate copy, which os never itself used, will backup fine. All that needs to happen then is that the database gets closed and re=opened reasonable regularly - say daily.


I have clients whose FileMaker databases I maintain in this way without having to be on site.

Explore "sharing" in the help system for more details.


Mac since 1984, Apple since 1978
MacBook Pro, iPhone 5, MacBook (in living room for iTunes and searching for recipes), iPad
Re: Filemaker on two workstations w/ shared DB
oldMacMan #12038 09/28/10 05:00 AM
Joined: Aug 2009
OP Offline

Joined: Aug 2009
Thank you so much. There are some very clever ideas here! Sorry it took so long to get back to you with a thank you but things got a little hectic.


Mid 2010 MacBook Pro 13"
2.4GHz, 750GB SATA HD, 8 GB RAM, OS 10.7.5
1 HDX1500 2TB Ext.HD, 2 HDX1500 1TB Ext.HD
HP Laserjet 6MP printing postscript via 10/100 Intel print server
Netgear WN2500RP Range Extender (Ira rocks!)
Linksys WRT1900AC Wireless Router
Brother MFC-9340CDW Color Laser
iPad Air
Re: Filemaker on two workstations w/ shared DB
slolerner #12042 09/28/10 08:55 AM
Joined: Sep 2009
Offline

Joined: Sep 2009
Glad to be if help!

Last edited by oldMacMan; 09/28/10 08:55 AM.

Mac since 1984, Apple since 1978
MacBook Pro, iPhone 5, MacBook (in living room for iTunes and searching for recipes), iPad

Moderated by  alternaut, dianne, dkmarsh 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.4.33 Page Time: 0.021s Queries: 26 (0.016s) Memory: 0.5953 MB (Peak: 0.6679 MB) Data Comp: Zlib Server Time: 2024-03-28 13:14:51 UTC
Valid HTML 5 and Valid CSS