splitting databases

L

Laura Rawstron

i realise that to use a database on a network the database needs to be split
- please could someone explain to me how to do this in simple terms! i have
made the database, but it now needs to be put onto the network.
 
R

Rick Brandt

Laura said:
i realise that to use a database on a network the database needs to
be split - please could someone explain to me how to do this in
simple terms! i have made the database, but it now needs to be put
onto the network.
Click to expand...

To split manually (which is how I would do it)

Copy your file giving the new copy the name you want your back end file to
have.

In the new back end file delete all objects except the tables. Place this
file in the desired location on the network for the shared back end.

In the old file (now the front end) delete the tables and leave everything
else.

Next in the front end file...

File - Get External Data - Link Tables

In the resulting dialog browse to the back end file location but do so by
going through Network Neighborhood - Entire Network. Do not use a network
shortcut or mapped drive letter. This will ensure that the link will use a
UNC path that will work for all users on your network.

After browsing to and selecting the back end file, chooses "Select All" then
[OK] to create links to all of the tables.
 
F

Fred Boer

Dear Laura:

When you "split" a database, you create two separate .mdb database files:
one file holds the tables of data, and the other file holds all the forms,
reports and queries and so on. The file holding the tables of data (often
called the "Back End"), is stored in a shared folder on the network server.
A copies of the file with the forms, etc., (often called the "Front End"),
is stored on each workstation. The "Front End" .mdb database files are
"linked" to the "Back End" .mdb database files, so that all users have
access to the same data. There is a database splitter tool available within
Access to help with the process.

There is good information here:

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

Post back if you have further questions!

Cheers!
Fred Boer
 
Top