Hello everyone.
I relatively new to MS Access and ODBC connectivity. I developed a MS Access interface that is used to connect to our SQL server systems. All of the tables are Linked tables (to the SQL Server). Here is my problem:
Sometimes when I make a change to something on the SQL system (such as deleting a column in a table or modifying security) it screws up the ODBC connection at the Access database. The only way to get things working again is to go to each PC that is running the Access Database (the actual database file (mdb) is on a network drive) and modifying the local ODBC (DSN) connections. Actually its not really being modified, i think its just being re-initialized because all I do is click configure and Next, next, next , etc. in the DSN GUI. Is there some way to avoid this? Can you reference DSN connections somewhere in Access or a file so that it does not rely on the OS DSN? In other words, you would be able to connect and use the Access DB from any machine on the network as long as you had the right SQL security....
Thanks,
John
Your limits are only as far as you set your boundries......
I relatively new to MS Access and ODBC connectivity. I developed a MS Access interface that is used to connect to our SQL server systems. All of the tables are Linked tables (to the SQL Server). Here is my problem:
Sometimes when I make a change to something on the SQL system (such as deleting a column in a table or modifying security) it screws up the ODBC connection at the Access database. The only way to get things working again is to go to each PC that is running the Access Database (the actual database file (mdb) is on a network drive) and modifying the local ODBC (DSN) connections. Actually its not really being modified, i think its just being re-initialized because all I do is click configure and Next, next, next , etc. in the DSN GUI. Is there some way to avoid this? Can you reference DSN connections somewhere in Access or a file so that it does not rely on the OS DSN? In other words, you would be able to connect and use the Access DB from any machine on the network as long as you had the right SQL security....
Thanks,
John
Your limits are only as far as you set your boundries......