1) How to UnSplit a database? 2) How to move back end ?

[Will]

1 - How can I UnSplit a database so the front end and back end are all back
in the same file again?
(We may or may not want to do this but want to find out how if we
decide to do it.)

2 - How can we move the back end to another server or folder on the
system... and make all the front ends point to it?

3 - Any problem if we attempt to modify tables in the back end from one of
the remote front end app's?
(The peer to peer computer we have the back end on doesn't have Access on
it.)

thanks for any help.

 

[Douglas J. Steele]

1) Make a copy of your back-end, and import all of the objects from the
front-end into it (under File | Get External Data)

2) Use the Linked Table Manager, or use code such as
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web"

3) Answered in your other post on the same topic.

 

[Joseph Meehan]

1 - How can I UnSplit a database so the front end and back end are all
back in the same file again?
(We may or may not want to do this but want to find out how if we
decide to do it.)

Import the tables to the front end or copy the other features to the
back end. (note always use copies when playing like this.) Then
reestablish the data sources.

2 - How can we move the back end to another server or folder on the
system... and make all the front ends point to it?

Re-link the front end to the tables in the back end.

3 - Any problem if we attempt to modify tables in the back end from
one of the remote front end app's?

You will still need access on the remote computer. Only the data file
is accessed on the server.