I have an access database on a server. Everyone the data and front end are both on the server. Problem: I need ODBC drivers to get to data on a SQL server. When link to the data on one machine, it works fine. But some machines the ODBC connection doesn't work! I have to update using the Linked table manager, then I go back to the other machine, it doesn't work there. The ODBC driver is named the same. Would there be any difference between an NT box and a 2000 box?
I know this can work! Can anyone remind me of all the steps?
I know this can work! Can anyone remind me of all the steps?
