Connection Failed SQLState: '28000'

  • Thread starter Thread starter John Petrucelli
  • Start date Start date
J

John Petrucelli

I am currently using an Access 2003 mdb database to run a stored procedure
sitting on SQL Server 2005. I got the following error:

Connection Failed:
SQLState: '28000'
SQL Server Error: 18456

When I use Edit mode and try to see the exact VBA line where the error
occurs, the stored procedure runs perfectly and returns the correct value.
When I go back to normal mode, I receive the above error.

Majorly frustrating.
 
Hi John,

just a thought ... when you are using the keyboard, DoEvents is executed
because the computer has to pay attention to the keyboard; try putting
this statement in the code before you run your stored procedure -->
DoEvents


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Back
Top