How do I split my database for multiple users in Access 2007?
in [Tables]
|
From: Ericksonclan on 26 Jun 2008 03:35 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?
From: Coffee Gal on 26 Jun 2008 08:13 Would it not be easier to set up groups / permissions? "Ericksonclan" wrote: > 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?
From: Golfinray on 26 Jun 2008 08:44 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. "Ericksonclan" wrote: > 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?
From: Jeff Boyce on 26 Jun 2008 11:54 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 "Coffee Gal" <CoffeeGal(a)discussions.microsoft.com> wrote in message news:A3B58745-78B7-4254-BA9F-5D50A699AEA7(a)microsoft.com... > Would it not be easier to set up groups / permissions? > > "Ericksonclan" wrote: > >> 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?
From: Armen Stein on 26 Jun 2008 12:24 On Thu, 26 Jun 2008 00:35:00 -0700, Ericksonclan <Ericksonclan(a)discussions.microsoft.com> wrote: >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
|
Pages: 1 Prev: network setup Next: Stephan Leban Background gradient problem |