janigorse

Well here again is my problem:
I have 2 identical aplications, that have access
to the same database (lets say Northwind.mdb).
When I'm trying to access to the database with both
applications one of them generates an error. I'm trying
to solve this problem so, that the second
application will wait and then access the base when the first will
finished. I don't have a clue how to do this. Can you help me please?

Thanks,
Jani

Shurik12

Hi,

It woud be nice to know what kind of error you are getting.

In general to see whether the database is already opened by another user you could check for the .ldb file which is generated when someone opens the .mdb file.

Peperl

You could open the adocd, give the values of the fields to the textboxes, combos, etc, and close the connection, and when you update or add new values, return to open the connection, save it and close again the connection.

When you re-open the connection, i think you could test if the database is being using by other application using the On error procedure ...

Is only an idea, 'cos I made something like this time ago ... but that doesn't have to mean that it is a good idea.

janigorse

Quote:

---

Originally Posted by Shurik12
Hi,

It woud be nice to know what kind of error you are getting.

In general to see whether the database is already opened by another user you could check for the .ldb file which is generated when someone opens the .mdb file.

---

Hi! Thanks for reply. Im getting this error:
"Run-time error '3356':
You attempted to open a database that is already opened exclusively by user 'admin' in machine 'W05'. Try again when the database is avaliable"

Well, I completly understand the problem. What I don't know is: How to tell the application to "wait for 2nd to finish with accessing the database"??

irri

Quote:

---

Originally Posted by janigorse

Hi! Thanks for reply. Im getting this error:
"Run-time error '3356':
You attempted to open a database that is already opened exclusively by user 'admin' in machine 'W05'. Try again when the database is avaliable"

Well, I completly understand the problem. What I don't know is: How to tell the application to "wait for 2nd to finish with accessing the database"??

---

peperl allready gave u this option, Use an disconnected recordset. Or get a databace program that allows multiple users.

janigorse

Quote:

---

Originally Posted by irri

Or get a databace program that allows multiple users.

---

Well here is the catch! I only need 1 user to access at the same time. I just want to acomplished that one application wait. And I really don't have a clue how to do it. Thats it! Thanks guys!

irri

Quote:

---

Originally Posted by janigorse

Quote:

---

Originally Posted by irri

Or get a databace program that allows multiple users.

---

Well here is the catch! I only need 1 user to access at the same time. I just want to acomplished that one application wait. And I really don't have a clue how to do it. Thats it! Thanks guys!

---

there is a windows api call which waits until a pid is done (processor id), you could use that for your application.