I am sharing an Access 'invoice' across three computers.....

[lrfowler]

So..I am sharing an Access database (an invoice form) across 3 computers.....
It was working fine for 2 computers......


But now it doesn't work for 3 computers....

Any ideas?

[June7]

How are you 'sharing'? Is this a split design? Does each user run their own copy of frontend?

[lrfowler]

Ok..very good question........So, we also share the database front-end...................I have a shortcut for each user to the database front-end in the public folder.......
Should each user have their own front-end?......rather than a short-cut?

Thanks!

[June7]

Here is how I manage multi-user db
http://forums.aspfree.com/microsoft-...ue-323364.html

[lrfowler]

is there a neasier solution?
Can Access 2007 automate it somehow?

[lrfowler]

i fixed it...
I just copied a copy of the front end to each PC...

[June7]

If you want to automate replacement of each copy with later versions, will need script like I describe in referenced thread.

[JoeM]

I do something similar, but in a little different manner.

I keep the most recent copy of my front-end somewhere on the network. I give all my front-end version numbers, so if I update it, I "up" the version number.
I then have a batch file that when run will look to see if you have the most recent version number on your computer. If you do not, it will delete the copy on your computer, and copy the most recent one for the network on your computer, and then open that.

So what I then do is put a shortcut to this batch file on everyone's computer, and this is what the click to open/run the database. That way, whenever I update my front-end, I just need to update the version number in my batch file. That ensures that everyone is running the most current version.