Unspecified Error Accessing O2K Database with asp

[BrewGuru99]

I've got an Access 2k database that I'm trying to open up with asp code. If I open the page once, everything is fine (and dandy), but if I reload, or open another page that connects to the same database, I get an "Unspecified Error" the moment I try to open a connection.

I have found that if I open the database and then close it with access, I can reload the webpage one more time before I get the error.

Also, I am developing my pages on win98 with personal web server, if that is of any importance.

This is driving me batty... I've tried everything I can think of.... which happens to be very little, but still...


set conPrivate = Server.CreateObject("ADODB.Connection")
conPrivate.Open "private" 'error occurs here.




Brewguru99

[BrewGuru99]

I really need help on this one... I'm going batty!

I don't know if it's something I'm doing, or something wrong with my system, or if it's just the O2K (office/access 2000) database. I'ed like to believe it's the O2k version, because I've had many problems with large 02K databases becoming corrupt. This paticular database, however, is only 200KB.

Please post any comments, even if it's just to say you don't have a clue Atleast then I won't be alone!!!

Thanks.

Brewguru99