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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy