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
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