Modifying an existing Access 2000 database

[=?Utf-8?B?a2F0aWVq?=]

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

"katiej" <ka****@discussions.microsoft.comwrote in message
news:27**********************************@microsof t.com...

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?

[Paul Clement]

On Mon, 5 Feb 2007 05:11:00 -0800, katiej <ka****@discussions.microsoft.comwrote:

¤ 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/lib...ffice.10).aspx
Paul
~~~~
Microsoft MVP (Visual Basic)