hi. im using ms access 2003 and vb 2010, i already have 3 different vb apps, and i want to access a single database over the lan. but i dont know how. is this possible using a client-server type or is there much simpler way to access the database?
-
-
The DB file must be stored in a shared location and all the applications needs to point to the same location. -
In addition to whats stated below, be careful about read/write access. You can do it just fine other wise. Hopefully, you are just doing read access.Comment
-
tnx for all the replies! Appreciated it.Comment
-
The best way to share a DB is to use it with sql.
install SQL server on server pc with a SQL Managment Studio
attach the database in the server
then in each computer add the data base from another computer
you must enable the firewall to allow the SQL path through it, add the 2 ports: 1) 1344 as tcp, and 1343 as udp.Comment
Comment