I've been using Access 97 and am trying to convert my ASP front end to use Access 2000. I've encountered some problems with converting my code to use ADO objects. Well I managed to work through most of them but there seems to be one problem I keep encountering....
When I first make the connection, everything works fine. Then I close the connection in my code. The next time I need to open the connection again, I get an "Unspecified" error. If I wait for about 1-2 minutes, then the connection works again, but I must wait again before making another connection.... If anyone knows what I'm doing wrong I'd sure appreciate the help.
webserver - Win2K advanced w/ IIS 5
database - Access 2000
Thanks,
Scott
When I first make the connection, everything works fine. Then I close the connection in my code. The next time I need to open the connection again, I get an "Unspecified" error. If I wait for about 1-2 minutes, then the connection works again, but I must wait again before making another connection.... If anyone knows what I'm doing wrong I'd sure appreciate the help.
webserver - Win2K advanced w/ IIS 5
database - Access 2000
Thanks,
Scott