cannot delete table

T

troy

I'm trying to run a make table query in which it deletes the current table
and recreates it, but I am getting "you cannot delete the table, it is in
one or more relationships. Delete the relationships in the relationships
windows"

I don't have any relationships in this database! help!

Troy
 
G

Guest

Troy,

Right-mouse click and select Relationships . Once your relationship window
is displayed, right-mouse click again and select Show All. See if this shows
any relationships and delete any links to the table you would like to delete
with your query. Are there any fields in your table that use a lookup to
another query or table?
 
G

Guest

Do you have any queries that join this table and others? Do you use it as
part of a Lookup table? How about subdatasheets? Guess what....

Instead of dropping the table, why not just delete all records and append
new records to the now blank table?
 

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

Top