Duplicate tables (1 Viewer)

BJF

Registered User.
Local time
Today, 10:09
Joined
Feb 19, 2010
Messages
133
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

Well-known member
Local time
Today, 10:09
Joined
Apr 9, 2015
Messages
4,339
i have never seen it to that,
but yes, if the original table is OK, delete the # ones.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 10:09
Joined
Feb 19, 2002
Messages
42,970
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.
 

Users who are viewing this thread

Top Bottom