access database on a network

[Charlarry]

Hi,

We have an access database created with access 2000 that we were sharing
with two computers we need two people to access the database at the same
time, update records etc. We had this database on Windows ME and it worked
fine and hardly ever crashed. We have now upgrades to Windows Vista Business
and to Office 2007. We converted the databse to Acess 2007 and now it one
user opens it works fine but as soon as the other user tries and opens the
database crashed. Is this a known issue and any segestions for a solution?

 

[Tom Wickerath]

Hi Charlarry,

Possibly this issue?
Access may stop responding when you open a remote database
http://support.microsoft.com/kb/935366/

Also, is this database split into two files? If not, you should create a
front-end (FE) application file and a back-end (BE) data file. The FE file
should be on each users local hard drive. Only the BE file should be shared.
More details here (see the second paragraph on splitting):

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


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________