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

tomstefanou

New member
Joined
Nov 5, 2010
Messages
1
Programming Experience
Beginner
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

VB.NET Forum Moderator
Staff member
Joined
Aug 17, 2004
Messages
14,350
Location
Sydney, Australia
Programming Experience
10+
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.
 
Top Bottom