How to open access database which is looked in edited mode

I have access database which is used by some programe, and this programe is looking the database so no one can connect to it or even open it using MS access.

Is there any way to connect to the database using c# without closing that program?
Suma5566Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
borkiConnect With a Mentor Commented:
Access is designed to be a multi user program. I am not sure what you mean with "locked in Edit Mode".

If the Access DB is opened in "Default" mode, then, if a user opens a particular table in Design View, other users can't open that table in design view. Also, you should still be able to query and work on other tables.

If you open the DB in "Exclusive" mode, anyone else receives a "file in use" message.

Another option is to open the DB in "Exclusive Read-Only" mode, where you grant other users read-only access to the DB.

You could also make a copy of the .mdb file and operate on it, as access control is done via the .ldb file.
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
No.
0
 
Suma5566Author Commented:
Great, thanks so much.

I'll consider copying the database.

Thanks.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
AndyAinscowFreelance programmer / ConsultantCommented:
There are other possibilities but all required making changes to the other program - which you seemed to exclude.
Note the answer you accepted does say pretty much what I said - no.
0
 
Suma5566Author Commented:
i cannot change that application since it has been developed by some company.
all i needed is to read dome data from that database.
i may write some code to kill that applications process and then start it again after i finish reading from it.
0
 
AndyAinscowFreelance programmer / ConsultantCommented:
>>Is there any way to connect to the database using c# without closing that program?

Answer - No.
0
 
Suma5566Author Commented:
I found a solution.

I opened the database file ib MS Access and made database split, which will make another file that i can connect to.

:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.