keep tables in a separate db?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to post this in .tabledesigns, but I could not get a "NEW QUESTION"
form to pop up, so I posted this here.

I have maybe 30 forms and queries in a DB with a dozen tables on a laptop.
I would like to try taking only the dozen tables out of this DB and place
them into a separate DB, yet have the forms and queries still use these
tables as sources.

How do I do this?
 
Search the Access forums for front end/back end for lots of discussion
threads on how to do this, but here is the short version:

For a wizard-type approach, use Tools -> Database Utilities -> Database
Splitter.
To do it manually, make two copies of your database. Take all the tables out
of one (this we call the "front end", and it will be your program) and
everything EXCEPT the tables out of the other (we call this the "back end",
and it will be your data). Now, in the front end, go to File -> Get External
Data -> Link Tables. Leave Files of Type as Access and browse to & pick your
back end copy of the database. Select all of its tables.
 
Back
Top