Results 1 to 4 of 4

Thread: SELECT INTO query

  1. #1
    Join Date
    May 2011
    Posts
    2

    SELECT INTO query

    Hello,

    I have a SELECT INTO query and want to know how it works since I got an error all of sudden saying "You can't delete a table 'ABC': It is participating in one or more relationships. You have to delete the relationship."

    My query is like:
    SELECT ABC.* INTO ABC IN another_database FROM ABC

    Could someone explain the error?

    Thanks,

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Which rdbms? Maybe wrong syntax, try:

    select * into table_name from abc

  3. #3
    Join Date
    May 2011
    Posts
    2
    I am using Microsoft Access 2003. The syntax is ok. If I removed the relationship (it is a simple one) it works, but I am afraid that it might cause another problem due to lack of the relationship.

    From the error message SELECT INTO query seems to delete the table and re-create it, then transfer data. Is it right?

    And how to use SELECT INTO query without the mentioned error?

    Thanks,

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Don't know much about Access.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •