Drop constraint from a table

  • I have a table, which has got foreign key relationship with two other table in ACCESS2000 database. I want to drop that primary table but it gives me error

    "Cannot delete this index or table.  It is either the current index or is used in a relationship."

    I am trying to delete the relationship from code in VB by altering that table but no use. Anyone having any idea how to perform this task

    Thanks

     

  • Just open up the relationship window, select the relationship - delete it then you can delete the table.

  • AS was mentioned above, manually deltee teh relationships, make your changes, then recreate the relationships. Are you trying to do this via code?

    David

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply