At 13.22 in Security Part 2, When attempting to relink files, I get an error when attempting to execute the SQL. The error is that a Primary Key already exists. I did create a primary key in MSSMS after after getting an error that the Unique Index already existed. When I try to reorganize the index in MSSMS, it tells me that I do not have permissions to do so. Should I just relink the table without creating the index? That's what I will try next.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Server Lessons.