Unlinking and Linking Tables

[Surf_gal]

We've got an access database (A) that has a table linked to an old database (B) with old information. A report in database (A) uses the linked table.

At some point, we copied database (B) and populated it's table with new data and added two fields. The problem we have now is that the report in database (A) is still linked to the table in the old database (B).

Is there a way to unlink the table in database (A) from database (B) and relink it to database (C)?

Is it simply deleting the linked table from database (B) and then linking to the table in database (C)? Or will that mess up the report?

I really don't want to mess up the report so any help anyone can provide would be greatly appreciated.

 

[SydneyGeek]

Yes, that should work as long as all of the field names (and the table name) in Database B are the same as the corresponding ones in Database C.
Try it, check out the reports, and if things work as expected, you're OK. If not, you can always re-set the original link.
Watch out that things don't get confused if the databases are shifting around to different network drives, though. Also, make sure that people only update the table in Database C or you'll start missing information. I'd suggest archiving Database B (zip it, and delete the original) once you're happy about the data in C.

Denis

 

[bat17]

In Tools>Add-Ins there is a linked table manager which will let you switch where tables are connected to.

Peter

 

[Surf_gal]

Thank you both so much!