why does the db open as read only when I log on as a diffenrent u.

[taz]

i saved the db to a shared drive. each user has permissions set. when i log
on to my pc as myself i can open the db using the different usernames. but
when i log on to my pc as a different user the db open as read only.

 

[Joan Wild]

You need to be clearer on what permissions you are referring to - Windows or
Access?

All users need read/write/create/delete permissions on the folder where the
mdb file is located. This is so they can create/delete the associated ldb
file. Without that they can't create the ldb and so the mdb is opened
exclusively.

 

[John Mishefske]

i saved the db to a shared drive. each user has permissions set. when i log
on to my pc as myself i can open the db using the different usernames. but
when i log on to my pc as a different user the db open as read only.

As Joan stated you will need to be clearer on whether this is a operating system or Access
workgroup issue.

I'm assuming it is an operating system issue. Is this A2000 on an XP system? Access will
compact a database to a defined TEMP location and then copy back the compacted database
which then has different modified permissions.

Try turning off Compact On Close if you have that set in Tools, Options.

You might also try opening permissions on your TEMP directory and see if that helps
(but only if you are using A2000 and XP).


http://groups.google.com/group/comp...2?q=mishefske+compact&rnum=4#6510bc258cdcad52