Sharing Access Databases

D

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
 
R

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
 
D

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
 
D

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
 
Top