If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
merging databases
I have an Access 2003 database containing about 150
tables. Almost all of the tables use an autonumber field as a primary key. How do I merge records from two copies of the same database from two different users? The problem is that the autonumber fields will overlap. One solution I thought of is to use a two field primary key for each table where one field was an autonumber field and the second field is a unique user id. Is this the only way to do it? Are there better ways? Thks Miles. |
Thread Tools | |
Display Modes | |
|
|