Relationships trouble

  • Thread starter Thread starter MikeR
  • Start date Start date
M

MikeR

I have a DB (2000) with a number of tables, tableID being the one of interest. I
need to import a new tableID (it has added fields). I import it and get
tableID1. I need to rename tableID to say tableIDBAK, and rename the new one
from tableID1 to tableID. No problem until I try to delete tableIDBAK. Access
complains about a relation to another table, but when I look at the
relationships, I don't see any. Is there a way to see that, so I can set the
relationship for the newly imported table?
Thanks,
Mike
 
Try right click/show all in the relationship view. Plus you can check
your objects dependences. To do this just right click on the table and
choose object dependences.

David
 
Also the hidden table MSysRelationships holds all relationship info

Pieter
 
Also the hidden table MSysRelationships holds all relationship info

Pieter

gumby said:
Try right click/show all in the relationship view. Plus you can check
your objects dependences. To do this just right click on the table and
choose object dependences.

David
Click to expand...



--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to create MDE File 3
Access is unable to create a MDE 6
How to make the MDE file 3
Problem saving Database as .accde format 11
Can't make MDE 3
Access Loop a datamacro in Access 2010 using vba code 0
Saving current row on Form exit 1
convert to MDE file 2

Back
Top