Post reply

Runtime error 18456

  • November 29, 2006 at 9:34 am

    #67818

    Hi

    One of the users on our system gets 'runtime error 18456' when he tries to log onto an Access 2003 adp with SQL Server 2000 back end.

    Has anybody come across this before and managed to resolve it.  Entries on the Web suggest a SQL problem - but it's only for one user - who apparently has the same rights as everyone else??

    Any help would be gratefully received.

    Thanks

    Paul

  • November 29, 2006 at 11:31 am

    #674758

    I have come across this a number of times with different access points.

    I have resolved this two ways, one is below the other is reinstalling SQL Server. 

    You can try running the below MSSQL Server Stored procedure or just drop the user and login from the database and SQL server then add them back in >>

    EXEC sp_change_users_login 'Update_One', 'UserName', 'login'

    You can also replace the above 'Update_One' with 'Auto_Fix' - See Books Online for further details about the referenced proc

    The only way the error has been resolved for me 100% of the time is when I have reinstall SQL Server.

    Also you could look to see if you are using a ODBC connection on the client computer for the access point, some times the drivers get corrupted

  • November 30, 2006 at 2:42 am

    #674868

    Hi

    Many thanks for your help.  I need to get this one person to login and test your sp.  I sure hope to avoid re-installing SQL Server.

    I much appreciate your time.

    Paul

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply