I had previously enabled named pipes. Since I have changed the authentication method I can no longer connect using either method to SSMS. I noticed also that both...

I think I have done everything above, but my odbc is still not working. This is what I get

Connection failed:

SQl State 08001

SQL server error 1326

Microsoft [SQL Server Native Client 10.0]Named...

I have created the new login, given it a password and set the default database. I am confused about the next step of "map a user". Sorry

OK, so I have done that. My SQl Server Authentication is now set on "SQL Server and Windows Authentication mode". I dont see any where on the properties page...

Gail, many thanks for your reply. The command worked and my database is accessible again. I guess I have a lot to learn but its good to know...

Thanks WIlliam, the DoCMD did the trick. I will try it without the other commands to see if it still works. BTW, really appreciate all your efforts on this...

sorry, but this is a case of fix one problem and move on to the next. Hope you dont mind

The next line that fails is :

CurrentDb.Execute "UPDATE tblRosterRunsDetail...

I sorted out the Native client driver and SQL authentication and performance is MUCH better. I may be kidding myself as in my test environment I am the only...

Thanks William, I found the native client driver and installed it on the client pc. I tried some basic queries and although performance had improved a little, still nowhere...

Thank you all for the comments. I now have several things to try at least. The first of which is the Native client DSN. I tried to create...

Elliot, I'm guessing by your reply that I am wasting my time if I hope to use my Access Front End (which has hundreds of queries, reports & forms) and...