we have the database of Access in 1 network and front-end of VB to totally in another network? how to connect?

Question

If connection is possible then how to configure it?

Answer 1

Simply put, if you have all administrative rights and permissions, you should probably use a tunnel to bridge the 2 networks and place the Access database on a shared drive.



Note that I absolutely don't recommend this as it will be slow as hell and Access is not a database server, so don't count on it to perform at all.



A real solution would be to convert your Access DB to a real DB server like Oracle, Informix, MySQL or other similar products and use ODBC from your VB program.

Answer 2

Unfortunatly that's fairly confusing to shield an get entry to db... via fact there are numerous freeware equipment available which could tell the consumer the password of the get entry to db whether its risk-free. The simplst thank you to shield the db from outdoors modifying is a trouble-free trick I found out together as doing the comparable form of challenge... replace the 1st couple of bytes of the database document so as that once the app is closed, if taking off the db is tried the consumer gets an blunders asserting "Database format isn't known", yet once you open the db contained in this methodology, have it replace the 1st couple bytes decrease back to the unique, open the db, replace, replace or however, then when you shut the db, replace the 1st couple bytes so as that they are incorrect returned.

Answer 3

you need NLD (serial technology) if both networks are within one country or ILD for multi national link to connect distant networks. Both have WAN network links required mid range routers of L3 switches to have such link. You are talking about point to point link beetween 2 distant networks, are mostly connect with serial technology.