Replace Static Tables w/Linked

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

Guest

I have a big database ("LoanDB") that I did not setup - a college Computer
Science instructor did. I'd like to replace 5 tables in the database with
links to tables in a second database. The only problem is, these tables have
tons of queries and reports that are based on them.

What is the best way to go about removing these tables and replacing them
with linked tables, without screwing up all the queries and reports? If I can
do this successfully, it will make my life much, much easier!

Many thanks,
Gwen H
 
If all the linked tables have the same structure, table names, field names
and types, and relationships as those you are using now, it should not be a
problem. If there are differences, they will have to be delt with.
 
Yes, I realize that, but exactly how do I go about removing the existing
tables in the LoanDB and adding the links to the backend database tables to
the LoanDB? If I delete the existing tables first, that will screw up all my
queries and reports that are based on the tables. I can't just delete the
existing tables, then set up links to the backend database tables and rename
them to match the deleted tables, can I?

The backend database tables match the front-end database tables exactly. For
reasons I won't go into, I was copying data from the backend tables and
pasting it into the front-end tables every month. But as of Jan. 1 I won't
have to do that anymore if I can set up the linked tables.

Many thanks,
GwenH
 
Deleting the files in the front end will not affect your reports, forms, or
queries as long as you don't open any of them. I would create a backup copy
of my front end, delete the current tables, establish my links, then run some
test to be sure everything works as it should.
 
Thank you! That is wonderful news. If it works, I will avoid some MAJOR
headaches!

Happy Holidays!
GwenH
 
Back
Top