Duplicate Tables

[Guest]

I've tried to use the linked table manager to refresh my tables. I suddenly
have twice as many tables as I did before (in the Table Manager and now in my
database FE). Could I have accidentally linked to the backup back end? If
so, how do I undo this?

Nicole

 

[George Nicholson]

Delete the "extra" tables from your FE (this only deletes the links, not the
actual tables).

If they are all duplicates of existing tables, they will probably have a 1
at the end of their names (i.e., a duplicate link to tblMyTable will appear
as tblMyTable1 and you probably want to get rid of all the "numbered"
links).

Once you do that, check that the remaining links are to the "real" data and
not the backup. If they point to the backup, use the Linked table manager to
point them to the 'real' file instead.

By the way, I don't think the Linked Table Manager was the cause of this.
AFAIK, it can't add links, it can only refresh/replace existing ones.
However, using File>GetExternalData>LinkTables (or a code equivalent) could
easily add a set of "numbered" duplicates to your FE.

HTH,

 

[Guest]

George:

You're right, I did use File>GetExternalData>LinkTables. I've deleted the
duplicate tables safely, they did have a one after them. I'm so glad this
was not a problem causing event

Nicole

 

[dbahooker]

Nicole

Access shouldn't be used for Linked Tables any longer; if your company
does this then you need to reccomend to someone that you move to SQL
Sever

Linekd Tables are too slow, and not secure enough for real world usage

Access Data Projects are a LOT easier to deal with