Database triggers in Access?

Question

I have five databases that currently each have identical member tables. I need to incorporate these all into one, and I was wondering if its possible to do this via something like triggers (this is how I would do it in sql server) Or is there another way?

I should add that I dont know how to do queries /triggers across Access databases so the answer would need to include some sample code of how to do that.. or a link to some sample code..

Each database has a table called "members" and needs to keep that table within the existing database. However all members now need to be members of all 5 databases, so when new members are added to one database I need them to automatically be added to the others also.

Answer 1

I have extensive programming experience in Access (see my website at www.geocities.com/argeesoftware for some of my work) and if I understand your question correctly you have 5 databases which all have a table with the same name (example: each database may have a table called "Customers" for example) and you want to merge them into one? If so you need to run an append query that you can design in a few seconds, you will need to disable the primary key and remove some criteria from specific fields, you can get help from the "Access Help" on how to do this, if it's not what you are trying to do you need to supply more information, you can contact me at [e-mail] and I will gladly help you.

Answer 2

Are the five databases on the same network?

Are you trying to get rid of the five databases into one large master database?

You might be able to make one database in the middle of them all and then link the five to the master database. That way when you update one of the five, it updates just the master database (the linked table). That is if I understand you correctly and that is what you are going for and you are on the same network.

**Edit. It sounds like you need to run some kind of append query for each db into the primary one. The only problem is if you are using the same unique keys on each database, else it should be a breeze to do.

Oh, I forgot about edits. You will probably want to run off a last edit field or last added field in each of the 5 db's for the append. Not so easy. The old merge and purge dilemma.

Answer 3

Access uses primary keys and keys. Since it is designed to be used with SQL as well, I would think you could just place all of the keys from each individual database into one. All you'll have to do is decide which single key will be the primary.