shared but not shared

[John Milbury-Steen]

Hi Access Gurus,
I have a MS Access 2003 database on a Windows server which is supposed
to be shared. However, only one person at a time can use it. If it is
already in use by one person, the second person who tries to access it
cannot. When the latter clicks on the icon, he gets the hourglass for a
second, then it disappears without any error message.
To simplify the problem, I created a ridiculously small database, one
with only one trivial table, and I have the same problem. If person A is
using it, B can't. If B is using it, A can't.
In the database Default Open Mode is "shared." I think, but I'm not
sure, that two people could use it simulataneously in the past. What has
changed is that our server switched from Novell to Windows and the version
of Access changed from 2002 to 2003.
Any ideas?

 

[Rick B]

Do your users have full access to the folder on the server in which your
file lives?

 

[Joseph Meehan]

Hi Access Gurus,
I have a MS Access 2003 database on a Windows server which is
supposed to be shared. However, only one person at a time can use
it. If it is already in use by one person, the second person who
tries to access it cannot. When the latter clicks on the icon, he
gets the hourglass for a second, then it disappears without any error
message. To simplify the problem, I created a ridiculously small
database, one with only one trivial table, and I have the same
problem. If person A is using it, B can't. If B is using it, A
can't. In the database Default Open Mode is "shared." I think,
but I'm not sure, that two people could use it simulataneously in the
past. What has changed is that our server switched from Novell to
Windows and the version of Access changed from 2002 to 2003.
Any ideas?

Three likely issues.

All users need full access, read, write, create, delete, edit... to the
directory where the file is located.

Many networks are just not up to the task

Shared databases should be accessed using a split database design with a
front end on each users PC having forms queries etc and a back one that only
warehouses the dynamic data.

 

[John Milbury-Steen]

Do your users have full access to the folder on the server in which your
file lives?
Yes, they all have full access.

 

[John Milbury-Steen]

Each user has full access to the shared directory. A user cannot enter the
database if another user is already using it.

 

[Joseph Meehan]

Each user has full access to the shared directory. A user cannot
enter the database if another user is already using it.

Make sure the users are not opening it up "exclusively"