Subject: Access ADOX - delete PK
Posted By: Derek_05 Post Date: 12/14/2005 9:56:19 AM
Hi there,
I am currently trying to delete an existing Primary key within a Table of a DB and assign a new one using VB (ADOX) in MS Access.

My code is working for the part to create a Primary key (through test), but I cannot figure out how to delete the existing PK with VB Code.

I know how to do this in the design view but I want to be able to do this on the GUI side (VB Code, if possible?).

Please reply if you can help, any help and advice will mostly be appreciated. Thank you all.

Derek



Go to topic 37609

Return to index page 417
Return to index page 416
Return to index page 415
Return to index page 414
Return to index page 413
Return to index page 412
Return to index page 411
Return to index page 410
Return to index page 409
Return to index page 408