Software·43,777 discussions

Up Dating an Access 2000 DB

Locked

I have created a master Database in Access 2000 with about 15 fields. I have five other databases with the same 15 fields plus a few more fields. I want records from these databases to appear in the master database. Only the same 15 field. all six databases are on the same server. So what is the best way to do this with the least amount of work?

Topic

Reply To: Up Dating an Access 2000 DB

In reply to Up Dating an Access 2000 DB

One method is to create a linked table in the client databases to the master database with the shared 15 fields. Then on the client db link the master record (linked table in the master) to a record in a new table on the client with a UID.This table will have the UID and the extra fields relevant only to the client.
The UID should start with a prefix for that client (i.e 02xxxxxx) so you can always tell from the master record which client created it.

This way will require a bit more work to create the record but it can be done. (I can help on that if needed)
As the db’s are all on the same sevrer it should not have a significant impact on speed.
If there is a lot of changes of the master record then there is a the possibility of record locking by 2 or more clients. However this will prevent 2 people changing the data at the same time and sync problems if all of the data is stored localy. If the record locking is an issue add another fieled to the record flagging that someone is accessing the record. This will then need an admin control to remove the record incase it gets corrupt.(it will happen at some stage)

Reply To: Up Dating an Access 2000 DB

In reply to Reply To: Up Dating an Access 2000 DB

Poster rated this answer.

Reply To: Up Dating an Access 2000 DB

In reply to Up Dating an Access 2000 DB

This question was closed by the author

[Author]

Replies