i have developed an access application for a sql backend database, and this error message:
connection failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Diver[SQL Server]]login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
keep popping up everytime i access SQL for the first time.
i know this is the login parameters, which i can wait for it to query me about it, however, to ease the users, is there a way for me to code it so i can open up a input box to allow users to enter the parameters?
i am using link tables in access to get to the data in the sql database.
Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!
Or try our Ask An Expert service to answer any of your questions!