Rejoin a split database

[James Ivey]

Is it possible to "rejoin" a split database?

James

 

[Guest]

Yes.

Import all tables from the Back End into the Front End.
Delete all the linked tables in the Front End.

Be sure to import or re create the relationships.

 

[Guest]

Yes

delete all the linked tables from the Front End, then import the tables from
the back end.

Be sure to import/Create the relationships.

 

[James Ivey]

Good deal. Thanks Tom

James

Yes

delete all the linked tables from the Front End, then import the tables
from
the back end.

Be sure to import/Create the relationships.

 

[John Spencer]

Yes, you can use the built-in tool or you can use VBA code to relink the
tables.

Menu Tools: Database Utilities: Linked Table Manager

Code Example at
http://www.mvps.org/access/tables/tbl0009.htm

'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

 

[Tony Toews [MVP]]

Is it possible to "rejoin" a split database?

Why? Poor performance? Visit the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Reasons why you should keep the database split.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info.

See the Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/