Connection Failed SQLState: '28000'

[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.

 

[Alex Dybenko]

Hi,
if you would post VBA code you using - this can help to find the problem

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[strive4peace]

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
*