Question How to update a database already opened by another aplication.

[tomstefanou]

Hello everyone.
I have a database let's say db1.mdb that is opened by app1.exe
db1 has a table named Users
Table Users has 3 fields
ID,User,Status
i am creating app2.exe that will have 2 buttons.
Button 1 will set the value of field Status to false,
and button 2 will set the value to true.

What i want to know is...
1) How can i change the value of the field.
2) How can i make sure that app1 that has the db1 opened will immediately see the changes in the database.

P.S I am able to locate the correct record using find method.

Thank you all in advance.

 

[jmcilhinney]

There's nothing out of the ordinary in what you're asking for. It's just ordinary, run-of-the-mill data access. All you need to do is read up on ADO.NET, which is the standard .NET data access technology. You can follow the Data Walkthroughs link in my signature or read up on it in any of countless sites on the web. You might also like to work through a good beginners tutorial, which will always include data access. Home and Learn is a good one you could try.