Discussion Locked

Access disconnected from SQL server

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Today I went to change stuff in my SQL 7 database (on a faraway server) using Access 2000, as I've done many times before. My datalink properties seem to be the same as ever, and the 'test connection' button says the connection is successful.
The database window says it's disconnected, and I'm buggered if I can figure out why.
Where have I failed?

3 replies

by oleemymoh

1- you must sure that your setting in connection button saved properly after test is successfull

2- check your startup form, may be you have wrong connection string which disconnected the database when these form loaded.

by dougaaa4

Turns out one of my MDAC components was somehow replaced by an earlier version that didn't work. Of course it took re-installing windows (ugh), and IIS before I figured it out.

This discussion is closed to new replies.