Sharing Access Databases

[Drew]

I have a peculiar problem with a user's database. The database resides on
our file server, and the user has a shortcut to it. The problem we are
having is that when the updating user uses the database, and someone is in
the database read-only, then the updating user gets error messages. How can
I stop this madness? According to Tools > Options > Advanced the MDB is
shared.

Drew

 

[Roger Carlson]

It is likely a network rights issue. Make sure that all the users have ALL
rights (Read, Write, Delete, Modify) to the DIRECTORY where the database
resides. Access creates a locking file (.LDB) which the users must have
rights to write to and delete. Network administrators love to restrict
these rights, but for an Access database, they are necessary.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Drew]

The funny thing is, the database opens fine, no problems if only 1 user is
opening it. But it doesn't create an LDB file for locking. Why does the DB
still work although there is no ldb?

Thanks,
Drew

 

[Drew]

Found it... when in doubt, compact and repair...

Thanks,
Drew

 

[Roger Carlson]

Access WILL open a database without creating an LDB, but it opens
exclusively. Therefore it is read-only for everybody else.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Drew]

Actually, it wasn't the compact & repair... for some reason the read-only
people didn't have write/delete perm. to the directory, therefore it
couldn't write the ldb...

Drew