September 27, 2005 at 10:06 am
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
September 28, 2005 at 1:06 am
Just open up the relationship window, select the relationship - delete it then you can delete the table.
September 29, 2005 at 4:58 pm
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