Replace Static Tables w/Linked

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
 
G

Guest

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.
 
G

Guest

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
 
G

Guest

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.
 
G

Guest

Thank you! That is wonderful news. If it works, I will avoid some MAJOR
headaches!

Happy Holidays!
GwenH
 
G

Guest

And a wonderful Ramhanquanzmass to you!

Gwen H said:
Thank you! That is wonderful news. If it works, I will avoid some MAJOR
headaches!

Happy Holidays!
GwenH
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing a Linked Table 1
Access front end linked tables to MySQL without ODBC? 0
Relationships in linked tables 2
Replace existing tables with links to ODBC sources 3
Linked Tables - Do I Need DNS on end users PC? 1
Problem with DoCmd.CopyObject for copying SQL Server linked tables in Access 2003 0
FE Security for Linked Tables & purpose of Shortcut 1
Preventing updates to Linked SQL Tables 1

Top