Set primary key using macro

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.
 
S

Steve Schapel

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.
 

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

Append Crosstab Query to Existing Table 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
sqlite-odbc write conflict 2
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Setting column width in a table with a macro is not working 0
VBA word change keys 0
Macro function in Word 2
Macro to copy table of contents to a new doc 0

Top