dgravitt
asked on
Setting ODBC connections on opening Access
Most all of my Access databases use ODBC connections to Oracle tables. Usually, I set these with a .reg file when a user needs the DB. Is there a way to set the ODBC connection with a VBA script when the database opens. Seems it would be easier than having users run the .reg file, which requires admin rights.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER