Duplicate tables

[BJF]

Hi,

After my database got corrupted at one point and after running compact and repair, Access automatically created a duplicate of every table in my database with a 1 next to the name.

Example- if i have tblClients, then i also have tblClients1 .

And if i add records to tblClients they are also being added to tblClients1 even though the recordsource of my Client form is set to tblClients.

Do i need to leave them there or can they be removed/deleted????

thanks for any suggestions

 

[Ranman256]

i have never seen it to that,
but yes, if the original table is OK, delete the # ones.

 

[Pat Hartman]

Make a couple of backups before you do any deleting.

If the "1" versions are links, the data duplication makes sense since they are pointing to the same BE but how they got created to begin with is a mystery.