Create a Primary key in a Query

Swifey

Active Member
Joined
Jan 16, 2003
Messages
421
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

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
Hi
Can you explain what it is you are trying to do? What are the queries doing?
Andrew
 

Swifey

Active Member
Joined
Jan 16, 2003
Messages
421
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

MrExcel MVP
Joined
Sep 9, 2004
Messages
5,432
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

Active Member
Joined
Jan 16, 2003
Messages
421
My database is used for other things
 

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
Hi

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

Martin
 

Forum statistics

Threads
1,078,100
Messages
5,338,242
Members
399,216
Latest member
Macho99

Some videos you may like

This Week's Hot Topics

Top