unspecified error change conn mode

[mike@fnesse.com]

Hi,

Can anyone tell me why, if I have an access database open and a table open locally I get a connection error, that’s understandable but when I close the table and refresh the ASP page I get an unspecified error. Then to make it work again I change my connection mode to read only or 1, do a refresh, it then works and then change it back to read/write or 3 and its fixed.

It’s no big deal, I just have to remember to do it, if I make the mistake of running an ASP page linked to an open table.

Also it doesn’t always do it, please email me if you have the answer, mike@fnesse.com

Cheers,

Mike.

[Kuriyama]

Can you post the error code you are getting?

Are you closing that connection? You might want to wrap it in an on error resume next and then make sure that you close the connection. That is a shot in the dark though.

[mike@fnesse.com]

Thanks Kuriyama,

I’ve dealt with this problem for ever, and just worked around it as I said but it’s been bugging me and I’ve been wanting to get to the bottom of it. I think your shot in the dark is the answer! Soooo many pages and yes I am bad and sometimes forget to close a connection.

Thanks again,

Mike.