second user unable to open Access 2000 database

D

dennisthemennis

We have an Access 2000 database on our server. It has been working - shared -
for about 2.5 years. about a month ago when the second database was opened
and the user went to the first form the with an "Action failed" message on a
macro that is performing the 2nd of 2 "gotocontrol"s. The first time it
happened I recreated the database from one of the backups and brought it up
to date. It happened again 2 weeks ago when I was on leave. Once again I
reset it up but the next day it did it again and I have been unable to get it
to work with 2 users. can anybody help please !!
 
A

Arvin Meyer

The problem is probably caused by the first user's options being set to open
the database Exclusively. Go to Tools ... Options ... Advanced tab, then
change the default open mode to Shared.

A second reason is permissions being changed on the server for the first
user. If modify permissions are not set (read, write, create, and delete)
the first user cannot create the LDB locking file and the database becomes
read-only for everyone else.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
D

dennisthemennis

Hi Arvin,
I checked but the database is set to share and all the permissions are
allowed except for "Special permissions". Any other ideas ??
 
D

dennisthemennis

Hi Arvin,
It is normally only opened on 2 different users machines and they are both
set to share in default open mode.
 
A

Arvin Meyer

If it isn't one of the 2 reasons (Server permissions, or Exclusive Opening)
the only other reason I know of is a locked table or data. Make sure you
don't have the table locked by default. Try setting the locks to No Locks
(also on the Advanced tab). Make sure all machines have the same settings.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
D

dennisthemennis

Arvin,
Sorry for the delay, both user machines are set to no locks and no record
locking. This is a bit serious isn't it ?
 
Top