Opening mulitple copies of a database application

  • Thread starter Thread starter PeterJC
  • Start date Start date
P

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?
 
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.
 
Back
Top