Tuesday, November 16, 2010

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

If connection is possible then how to configure it?We have the database of Access in 1 network and front-end of VB to totally in another network? how to connect?
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.We have the database of Access in 1 network and front-end of VB to totally in another network? how to connect?
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.

No comments:

Post a Comment