Splitting Access 2000 DB

[Karen]

A while back, you advised we should split our DB. We have
6 users on a 5Mb database on a network. I went through
the wizard and it split the db - I guess. But now I
cannot find the front end. Where do I find that? I can
open it and see the tables. Also, do I need to do that on
all 6 user's machines or just once will do it? Thanks.

 

[gr]

Hi, hope you make a backup.

the wizard steps and what you should have done for
splitting ..
1. by clicking split database, open the Create back-end
database dialog. here you choose the name and location of
the new shared database
2. give a name to the database that will hold all the
tables.
3. then the wizards creates the database that will hold
the tables (the one you named above) and makes the links
between the current database and the database containing
the tables.

you only split once and give copies of the front end to
the users.
be aware when distributing, you must write code to make
sure that all users can reach the back end.

 

[Albert D. Kallal]

The font end usually keeps the same name.

You might want to use a test database before you actually try this on
anything valuable.

The idea here is to eventaully to give each user a font end that has all the
forms and code. You then "share" the back end that has JUST the data on the
server side.

Here is some reading on splitting:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm