Duplicate tables after compacting and repairing db

[mapat]

Hello,

Why is it that after I compact and repair an ACCESS2003 back-end file, and then look at the ER diagram, duplicate tables show up? This is preventing some reports from running. Is there any tool to fix this?

Thanks everyone

 

[boblarson]

Hello,

Why is it that after I compact and repair an ACCESS2003 back-end file, and then look at the ER diagram, duplicate tables show up? This is preventing some reports from running. Is there any tool to fix this?

Thanks everyone

1. Are you looking at the relationships in the BACKEND, or looking at the Frontend? If Frontend, the frontend should not have relationships defined.

2. Can you post a screenshot of what you mean?

 

[mapat]

1. Are you looking at the relationships in the BACKEND, or looking at the Frontend? If Frontend, the frontend should not have relationships defined.

2. Can you post a screenshot of what you mean?

Well, the diagram is on the back-end. Somehow it's not pasting the screen shot, sorry.
Thanks again.

 

[boblarson]

Well, the diagram is on the back-end. Somehow it's not pasting the screen shot, sorry.
Thanks again.

You can't paste a screenshot here. You upload it using the Manage Attachments button.

 

[hoangtrang]

Can you give some more sample question and answers. How great your info is! It really useful for me. Thanks.