Remote connection problems

[maanton]

Hello people!
I run a site on asp and access.
The problem is when I browse a page I get the correct data, nicely formatted. BUT... if I either
click one of the hyperlinked fields or refresh the page, I get the following errorrovider error
'80004005' Unspecified error /Default.asp, line 15. Viewing my code, line 15 is the one that says
rs_offers.ActiveConnection = MM_sotiriou1_STRING
If I wait a while and do a refresh, or recklick a link, the proper data comes up
I have the feeling that the server is locking the .mdb file in some way. Any ideas?
Thanks in
advance.

 

[sfreeman]

Any help here?

http://www.experts-exchange.com/Web/Web_Languages/ASP/Q_20805034.html

Sam_F
"90% of the problem is asking the right question.

 

[maanton]

Thanks for your concern, but thankfully I found out what should I do.
Because the solution is really weird I post this guy's aadvice in case anyone ever needs it:

Originally posted by johnzstudio
I HAVE THE ANSWER!!!! I messed around with this until I found out what the hell was going on. When you get this error, you have triggered the problem, buy editing the database, or just having it open, when you are trying to use it in an asp page. The access driver gets it's knickers in a twist, and you have to free it. To free the driver, you must edit the asp page to attemps to use another driver for *.mdb i.e. put "DRIVER={dummy (*.mdb)}; " instead of "DRIVER={Microsoft Access Driver (*.mdb)}; " then load the page. you will obviousley get an error, cos it wont find that driver. then edit it back to normal: "DRIVER={Microsoft Access Driver (*.mdb)}; " reload the page, and as if buy magic, the refresh will refresh. and you won't have to wait for the timeout. Hope this helps anyone having problems. Let me know if it does