splitting a database on server Access 2007

[Bob H]

I have a database which is on a server, and now I want to split it so as
put the front end on users PC's.
Do I split it on the server and then copy the front end to local
machines, or put the database on my local machine and split it then move
the BE onto the server?

Thanks

 

[Maurice]

If you split it on the server the reference to the linked tables will
allready be in tact and you can deploy the front_end to the other users. If
you split it locally and then place the backend on the server you have to
relink all the tables again because the original location of the split tables
would be on your local machine. So splitting it on the server is not a bad
idea.

hth

 

[Arvin Meyer MVP]

Make a copy before splitting, then split on the server so you won't have to
relink the tables. After you're sure that the process work OK for you,
create an archive folder, and put the copy in it, as well as copies of the
front and back end of the newly split database.