ODBC connections between computers in a LAN networking

Dear All,



Please Advice :



At XYZ Company there are three computers admin installed windows 7 and windows xp, so no windows server

1. Comp X with IP 192.168.1.12 installed sql server and installed Microsoft Access

2. Computer Y with IP 192.168.1.13 not installed sql server and not installed Microsoft Access, but mounted Access Driver

3. Computer Z with IP 192.168.1.14 not installed sql server and not installed Microsoft Access, but mounted Access Driver



Which is desired; The computer Y and Z can access SQL Server in computer X by using ODBC

The problem is: ODBC settings in the computer Y and Z are not successful, although it has been tried

1. Firewall on computer X is turned off (extreme)

2. Sharing files have been successfully

3. Ping IP Computer X of Y and Z successful computer



When using OLEDB if there are colleagues who have a tutorial?

I tried searching the internet there is a VBA script, but still confused, whether it be affixed on each form, or in modules, and called each time the form is opened or how



Thank you in advance



Allan.Day

ODBC connections between computers in a LAN networking