Modifying an existing Access 2000 database

[Guest]

Hi have a table of customers in Access and wish to add a primary key and
unique customer ID. Have been warned that adding customer ID field will
corrupt existing data. Is there a way it can be done?

 

[Miro]

I do this thru adox.

Its a .COM addition to your project, but it does the trick for me.

Search google for ADOX.

It may not be the best way...but thats how i added my fields thru an access
table.

Miro

 

[Paul Clement]

¤ Hi have a table of customers in Access and wish to add a primary key and
¤ unique customer ID. Have been warned that adding customer ID field will
¤ corrupt existing data. Is there a way it can be done?

No it will not corrupt existing data. You can use Jet SQL DDL to accomplish this task.

http://msdn2.microsoft.com/en-us/library/aa140015(office.10).aspx


Paul
~~~~
Microsoft MVP (Visual Basic)