Search results

I tried this: All I got was this error: Run-time error '3295': Syntax error in DROP TABLE or DROP INDEX It did not delete the index, or remove the primary key. I did get it to work however by deleting the field in question (after making a table referencing the old primary key to the new...

Well, I didn't want to delete that field, just disable using it as the primary key in my database, and use a different (autonumber) field instead as the primary key. Is that what this will do (your first response):

I right clicked and added all the tables to the relationships window as you said (they were all there already except maybe one), still nothing showing up there that I could delete or that was related to the table / field in question. Let me clarify further. What I am actually trying to do is...

Sorry to revive such an old post, but I seem to be having a very similar problem. I was just wondering if the previous solution worked for the OP? I was also wondering if there was any simpler way to solve the problem than with the code posted above, as I am scared to use that much code. lol