Database with Multi Users

[cjany]

A microsoft Access database needs to be used by several users. Currently, if it is being used and another user tries to access it, they get a message stating "file in use". How can I make this database used by several users?

 

[alvechurchdata]

If you open the Options dialog from the Tools menu and look at the Advanced page you'll see the "Default Open Mode". It sounds as though you've got this set to "Exclusive". Change it to "Shared" for all users as a first move.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[dhookom]

Also make sure that ALL users have the permissions to create and delete files in the directory containing your MDB files.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[lameid]

cjany's post is most likely but dhookom is right (as usual). It is also worth noting that compacting and repairing technically recreates a database file and under windows it will inherit the permissions of the folder. So, setting permissions to just the file different from the folder is not a good solution as it will change when you compact and forget to reset permissions. (I heard you could get permissions to persist with filenames under Novell). Not sure if this is even an issue for you but definitely worth mentioning.