Connection to Already opened AccessDatabase Using C#

Question

5.00/5 (1 vote)

See more:

Hello,

I am Trying to Connect to an Access Database Which is Already Opened for other Purpose.
I think the Database is Exclusively Locked.
I have no Permission to Change the Accessiblity.
I have to Get the Live data From the Databse.

Is there any Method for Cloning the database so that whenever the Original DB sis Updated, it automatically gets Updataed in my (Clonned) Database?

Or is there Any Other Method to Connect to already Connected Access database Using C#.

Thanks in Advance.

Kindly Reply.

Lakshman

Posted 26-Dec-10 17:54pm

Lakshmancb

Add a Solution

2 solutions

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)

Dave Kreskowiak · Answer 1 · 2010-12-26T19:04:00

No, there is no cloning available in Access. There is also no notification service that will tell you the data has been updated. You have to poll for whatever changes you want, but that also means your database design must change to accomodate this.

The file is locked exclusively by Access when it's open. You cannot even copy the file since the copy operation won't be able to open it to read the file.

Eddy Vluggen · Answer 2 · 2010-12-27T00:14:00

Solution 2

Create a new Access-database, and import the tables into there using the "link table" wizard. Description of setting up table-links can be found here;

Link to external data[^]

You'll need the part that says "Link to data in another Access database" :)

Posted 27-Dec-10 0:14am

Eddy Vluggen