sharing small database

[wilkob]

I have written database to be used by 2/3 persons.
After finished the database on my PC I have hidden all database "stuff" (just the main form opens) and copied the file in a shared directory on my server.

I have set under tools -> options -> advanced the default open mode to shared, but when trying to access the database with multiple users it does not work.
Basically the first one that opens the database has the access. As soon as he/she closes the database, the other can access?????

Have I forgotten something?
Can someone please help?

 

[The_Doc_Man]

Please try to avoid multiple postings of the same question.

 

[mcadle]

The_Doc_Man is king in my opinion on networking DB's. But I would look into you network shared folder and make sure everyone has read/write/create/delete/modify rights to the folder and it is setup as a shared folder. As access has to create the .ldb file. Also, make sure in you options when you saved the file that it is setup for shared and not exclusive. You mentioned it, but make sure.

 

[wilkob]

Thanks for your replies. I just read a thread about splitting the database. I did this and this did the trick.
Table is now on the server (which get's backed up) and users have the frontend on their PCs