Create a Primary key in a Query

[Swifey]

Is it possible within a query design view to create a table with a primary key?

The reason why I ask is that when I update my table queries I have to delete my relationships between my tables created in a query design view.

As you can appreciate indexing can cut down the processing time by half.

Kind regards

 

[Andrew Fergus]

Hi
Can you explain what it is you are trying to do? What are the queries doing?
Andrew

 

[Swifey]

Within a query design view I create a table to another users database which contains customer sales figures.

The users links other tables which contain primary keys on cusno.to the one I create. If they create a relationship it stops me from refreshing there data.

 

[Andrew Fergus]

Unless I'm misunderstanding the set-up, can you create the table in your database and have the other users links their databases to yours? They would have a linked table in their database and as you add data to the table in your database, the data would appear in their database without any need to change / delete the relationships.
Andrew

 

[Swifey]

My database is used for other things

 

[pritcham]

Hi

Is it possible/practical for you to update your query definition(s) through VBA using the querydef object?

Martin

 

[Swifey]

Thank you for your feedback I have a go.