Database won't open for 2nd User

[Tenkenaid]

The Problem:
If user 1 has the file open. user 2 double clicks, gets an hour glass for a
second or two then it just acts like you did nothing. If user 1 closes the
file, then user 2 opens it, then user 1 can double click & reopen the
database without any troubles.

The two users that I really focused on are both running access 2007 with all
updates applied (checked version..it matches exactly)

The Work Around:
User 2 opens MS Access & then opens the mdb file from the file menu instead
of double clicking on the file or a shortcut to it. It opens just fine.

Does anybody know what causes this or how to fix this?

Thanks.

 

[Arvin Meyer [MVP]]

Just a guess. You haven't split your database and are running from the
server. You need to split the database and put a copy of the front-end on
each user's workstation, linked to a single back-end on the server. There is
a wizard, but the easiest way is:

1. Make 2 copies of the file, saving the original as a backup.

2. Delete the tables from 1 copy.

3. Delete everything but the tables from copy 2.

4. Compact each database if you haven't already done so.

5. Using Get External Data from the front-end, link to all the tables.

6. Make and distribute a copy of the front-end to each user's workstation.

 

[Tenkenaid]

Thanks for responding. The database is on the server and we never have done
this before. Never split the database etc. It was working fine until I got
a new computer. Why is it that if I open the database first the others are
still able to open from their shortcuts but it doesn't work the other way
around.

Thanks again.

 

[Arvin Meyer [MVP]]

The server is being careful about concurrent connection to the file. You may
also have a problem with your AntiVirus software slowing down or locking
files. No matter what, split the database and put a front-end on each
workstation. You are asking for corruption problems as well as this and
other performance problems if you don't. See Tony Toews FAQ at:

http://www.granite.ab.ca/access/splitapp/overview.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com