The problem is likely that you haven't given your users sufficient access to
the folder in which the database resides.
Whenever a database is opened, Access tries to put the locking file (.LDB)
in the same folder as the .MDB. As each subsequent users opens the database,
Access writes some information to this locking file. When the last user logs
out of the database, Access deletes the locking file. Therefore, your users
require RWXD on the folder.
The exception to this is if you open the database as read-only AND
exclusive. Under that combination, Access doesn't bother to write the LDB.
And, despite how it sounds, multiple people can open the database in this
way at the same time.
Doug Steele, Microsoft Access MVP
Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
> the access db is opened by user belonging to a group that has read only
> permissions to the database and relevant tables
> the vb 4.0 program tries to open the same database with:
> Set Db = DBEngine.Workspaces(0).OpenDatabase("dbName", dbReadOnly)
> Set RecSet = mastDb.OpenRecordset("prodmast", dbOpenTable, dbReadOnly)
> the open fails with error 3356 which sez the db is open by user soandso on
> machine machineName
> obviously i don't understand how to get concurrent use of the db, for even
> read only, can anybody help????