Rejoin a split database

  • Thread starter Thread starter James Ivey
  • Start date Start date
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.
 
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.
 
Good deal. Thanks Tom

James


Tom Ventouris said:
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.
Click to expand...
 
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
'====================================================
 
James Ivey said:
Is it possible to "rejoin" a split database?
Click to expand...

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/
 
Back
Top