Provider error '80004005'

[new2unix]

Hi,

Thanks to those who replied to my previous email about updateable query error. After changing the security to "change", the error was resolved. But now I got something different. If the page was loaded again withing a shrt frame of time, I would get the following error. If I waited a minute or so and refresh the page, the Access 2k db would get updated properly. Sounds like something to do with db opening and closing, if so, is there anyway to work around this problem? The db may be updated by multiple users at the same time.
======================================
Provider error '80004005'

Unspecified error

/chp2/chp5/insert_record.asp, line 5

======================================

Thanks

Mike

 

[foxbox]

Sounds like you are not closing and Set = Nothing your ADO objects. Always .close and 'Set = nothing' as soon as possible.

br
Gerard

 

[new2unix]

Thanks! That did the trick.

Mike

 

[jward]

Can someone clearify this, I'm having the same problem

Provider error '80004005'

Unspecified error

/index2.asp, line 16


I'm past the security part and i get the above error,
I'm new to ASP,VBScipt And Databases, I don't understand
what Foxbox was saying. I have no problem with my code
on IIS 5/Win2k PRO it only fails on IIS4/NT4

Thanks