Link to home
Start Free TrialLog in
Avatar of aerokevs
aerokevs

asked on

update data in the other pc

i have a program in vb. and we are using windows nt 4.0
the other pc is using my program and i am using it to. we are only using msaccess.. What will i do if i want that all the changes i made in my table be reflected to the other pc. without using sql server or odbc?
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

You simply need to make sure that the database is placed somewhere that both computers can access it. This can be achieved either by placing it on a file server or by sharing a folder on one machine and keeping it there. You then need to ensure that you set the appropriate path to the database in your application. This can most easily be achieved by running the application from the same folder as the database and using App.Path & "\MyDatabase.mdb" as the database name in whatever OpenDatabase/Connection.Open or similar statements you are using.
ASKER CERTIFIED SOLUTION
Avatar of Alfredo Luis Torres Serrano
Alfredo Luis Torres Serrano
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of aerokevs
aerokevs

ASKER

yes.. we used timer in doing our job...