How do I split my database for multiple users in Access 2007?

[Ericksonclan]

I have designed a Access 2007 database to be used by multiple users. Some
users will need edit/add capability and some will only have view capability.
The database will be put on a LAN. I figured the best route would be to splt
the database to BE and FE, then create 2 different FE; view only and edit.

Problem being, when I push the Access Database to initiate the Splitter
Wizard, it starts to create the BE then I get an error message that says
"Subscript Out Of Range", then the wizard stops. What does this mean?

 

[Coffee Gal]

Would it not be easier to set up groups / permissions?

 

[Golfinray]

If you have any errors in your code, you will not be able to split. Try and
compile before you split. You probably have an error there.

 

[Jeff Boyce]

Are you referring to Access security or to network security?

Access security, if I recall, was removed from Access 2007.

Network security may not work, as folks who need to even just use Access
still need read/write permissions to the folders so that the locking file
can be managed.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Armen Stein]

Problem being, when I push the Access Database to initiate the Splitter
Wizard, it starts to create the BE then I get an error message that says
"Subscript Out Of Range", then the wizard stops. What does this mean?

In addition to the other post about checking compilation...

You don't need to use the wizard. Splitting a database just means
having the tables in one DB, and everything else in the other.

Just make a copy of your database, and name it with BE. Make another
copy and name it with FE. Leave the original alone - it's your
backup!

In FE, delete all the tables. Link to all the tables in BE.

In BE, delete everything except the tables.

That's it.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com