Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 14th, 2005, 10:56 AM
Authorized User
 
Join Date: Dec 2005
Location: London, , United Kingdom.
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access ADOX - delete PK

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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with delete queries on Access Morgz1 VS.NET 2002/2003 0 April 10th, 2006 10:45 AM
Access ADOX - delete PK Derek_05 Access VBA 7 January 4th, 2006 03:32 AM
ADOX Access column add error kf9thdon@aol.com Access VBA 4 February 26th, 2005 04:05 PM
ADOX MSDASQL Access Properties Collection is EMPTY Xentrax Access 0 May 27th, 2004 10:36 AM
PK problem reindeerw Access 10 April 15th, 2004 01:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.