Set primary key using macro

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

Is there a way to set a field in a table as the primary
key in either the make table query or in a macro? Thanks.
 
Lynn,

I think the only way you could do this with a macro is to use a RunSQL
macro action, and enter a ALTER TABLE statement for the SQL Statement
argument of the macro. You can find more information by looking in
Access Help at the CONSTRAINT Clause topic.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Primary Key 1
MS Access Avoiding redundancy 1
How to use where statement?? 3
Access 2010 Form Issue's 0
Access Access Record Order 0
Do I have to set the primary key to include primary key fields? 3
Edit primary key values 3
emptying table 2

Back
Top