How to create multi-user database

[arius]

I've read instructions for making a multi-user Access 2007 database. Summary is:

1) Split the database
2) Put back-end part of the split onto shared drive


3) Make copy of front-end of the split and give to each user of the database
4) Open Tools, Options, Advanced Tab. Set the default open mode to shared and the default record locking to edited record. While in options area, go to general tab and turn off compact on close and name autocorrect.

These instructions were posted by an Ms-Access MVP.

My questions is about step 4. How do these settings get saved to the particular database that I am trying to make multi-user? None of these settings are in the Current Database Tab for Ms-Access 2007. Since they are in the general tab, does that mean all database I open with my copy of Ms-Access will take on these multi-user settings?

Thank you in advance for any details/guidance.

[ssanfu]

Since they are in the general tab, does that mean all database I open with my copy of Ms-Access will take on these multi-user settings?

No, the settings are per database.

I would change the steps to:

1) Split the database
2) Put back-end part of the split onto shared drive
3) Re-link the FE to the BE
4) Open Tools, Options, Advanced Tab. Set the default open mode to shared and the default record locking to edited record. While in options area, go to general tab and turn off compact on close and name autocorrect.
5) Make copy of front-end of the split and give to each user of the database