A
alex
Manage ODBC
Hello,
Using Access ’03…
I use Access and ODBC to connect to a variety of data sources, such as
Oracle and SQL Server.
Sometimes I need to modify a preexisting connection (change password,
re-link table, etc.). I don’t have administrative privileges to my
computer(s) (cannot access control panel) and have to modify my
connections manually; e.g., New > Link Table > ODBC Databases ()…
I assumed that there was a file somewhere that held the connection
information and that information could be modified within the file.
I’ve been unable to find such a file, however.
I’m wondering if anyone knows how to modify an ODBC connection without
using the wizard on the control panel or having to “reestablish” a
connection; i.e., does the information exist in a file that can be
modified?
Thanks,
alex
Hello,
Using Access ’03…
I use Access and ODBC to connect to a variety of data sources, such as
Oracle and SQL Server.
Sometimes I need to modify a preexisting connection (change password,
re-link table, etc.). I don’t have administrative privileges to my
computer(s) (cannot access control panel) and have to modify my
connections manually; e.g., New > Link Table > ODBC Databases ()…
I assumed that there was a file somewhere that held the connection
information and that information could be modified within the file.
I’ve been unable to find such a file, however.
I’m wondering if anyone knows how to modify an ODBC connection without
using the wizard on the control panel or having to “reestablish” a
connection; i.e., does the information exist in a file that can be
modified?
Thanks,
alex