Maintain Primary Key in Make Table Queries (1 Viewer)

[Gezza]

Hi, Hope someone can help,

Is there a way of keeping/setting the primary key when using a make table query?

Gezza

 

[jdraw]

What exactly are you asking? Can you describe what you mean - perhaps use an example.

 

[Gezza]

Hi Thanks for your response,

I'm using a Make Table query to export a table to another Access database (make a copy of it), the original table has a primary key, but when I run the query the resulting table does not have the primary key
This query is run using MS Visual Basic code
I've tried running the query without using the code with the same result

Thanks
Gezza