Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Make Table - Relationship Problem

Status
Not open for further replies.

carefully

Programmer
Mar 14, 2000
8
CA
I am trying to run a make table query based on a combination of other queries. It replaces an existing table
tblA

When I attempt to run it I get the message
'You cannot delete the table tblA; it is participating in one or more relationships'

However, tblA does not show up on the relationship window
even when I try the 'Show All' feature

Where am I going wrong
 
is it being used in one of the queries that are part of the Make Table query?

PaulF
 
Thanks for the suggestion but that does not seem to be the problem. Of course it is early here :)

I seem to have got round it by having the query make a differently-named table which I then rename to the original
after the query has run.

Looks OK but there might be some consequences I suppose
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top