Opening mulitple copies of a database application

[PeterJC]

I wrote a database application in Access 2000 that ran on a network, with
the applicaition itself on the server. The application would open
successfully on several computers at once.

The system has been changed to Windows Vista with Office 2007, and I have
converted the database application to the Access 2007 format. But I now have
a problem: if a user has the application open, then another user cannot open
it, getting the error message "Cannot lock file", although an administrator
can open it.

What do I do to fix this please?

 

[Arvin Meyer [MVP]]

Your problem is that you do not have a split database. You are actually very
lucky that the previous install didn't corrupt. After splitting, you need to
put a copy of the front-end on each user's computer. On the server, which
will have the back-end (all the data tables) you need to give everyone who
is allowed in the database every permission but full control if you want
them all to be able to access it at the same time.

 

[PeterJC]

Thanks, ARvin, i'll follow your recommendation.

 

[Arvin Meyer [MVP]]

There is a splitting wizard to help you do that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Tom Wickerath]

Hi Peter,

Here is an article that you might find helpful as well:

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm

This includes coverage of splitting a database, plus a whole lot more.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[PeterJC]

Thanks, Tom, for the help and references.