connecting two databases

Question

1.00/5 (2 votes)

See more:

Am having a msaccess db(used by others) and also a sql db(my db) too, whenever access database got row or data INSERTED, i want my db inserted with same row or data

ACTUALLY I NEED A TRIGGER KIND OF THING BUT IT WONT B POSSIBLE IN ACCESS

Note: am not having the control over that msaccess db.

Please help me with simple solutions if any??

thanks in advance

Posted 27-Mar-13 20:13pm

balagee99

Updated 28-Mar-13 1:52am

v2

Add a Solution

Comments

[no name] 28-Mar-13 7:59am

Do you really think that screaming at people will help? The only way I know of that might work for this situation is to poll the access db for changes. But I would recommend that you do something else and only use one database.

ZurdoDev 28-Mar-13 8:01am

Basically you need to poll at a regular interval. For example, INERT INTO SQLTable WHERE NOT EXISTS (SELECT * FROM accesstable). If you can't have any control of the access db you can't have it tell you when records are changing.

Maciej Los 30-Apr-13 17:29pm

Not clear, please, be more specific and provide more details.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SudhirKankal · Answer 1 · 2013-06-02T23:53:00

A) You need to create logs

For creating log you may create a generic table with 3 information & Sync flag
- Table name
- Primary Key (record identified)
- Action (Insert / Update / Delete)
- Sync (Y/N) ~ default during insert as 'N'

You can use triggers for doing an insert for

B) You will need an stand alone application which is running all the time at specific interval read this logs and connects to your choice of DB using JDBC and replicates information. On replication, either deletes the record or marks Sync flag as "Y"