Forum Discussion
gilbert7
May 27, 2020Copper Contributor
Need help to prepare a vba code
Hello, MS Access Database - ABC Query - Data i just wanted to code to open the ABC database and click on query Data. when i open query it ask for servername , login, password (pass thru) Onc...
George Hepworth
May 28, 2020Steel Contributor
gilbert7 Based on your description, one assumes that this is an Access accdb linked to tables in SQL Server, SQL Azure, or perhaps another server-based database.
In all of those cases, you need to correct ODBC Driver, the name of the server on which the database resides, the name of the database, and a valid login and valid password. PLUS the owner of that database must have given you permissions to use it. One assumes that, if you have a valid login and password, the DBA has given you appropriate permissions.
What part of this is failing for you, specifically?