Wow, I think we've pretty much come to a concensus that no one here knows the cause of this error. But, we seem to have nailed down the following: a. it occurs when the database has just been uploaded for no apparent reason b. it gets fixed automagically, also for no apparent reason I will do some research and report back in a few days if I find the answer. -- mattwarden mattwarden.com ----- Original Message ----- From: R.Livsey <R.Livsey at cache-22.co.uk> To: <thelist at lists.evolt.org> Sent: Wednesday, November 01, 2000 9:44 PM Subject: RE: [thelist] Access+ASP: database connection error > This has happened to us lots of times. For a while every time when I > uploaded a new database file it would do this. > > Try compacting and then repairing the database through ODBC settings. > > We found that restarting the server also fixed it - but you don't want to do > that every time you upload a new db. > An 'real' answer was never found as to why it was doing it, so I'm anxious > to see what the rest thing.