Access denied errors

[Andrew]

I have been getting some rather confusing access errors when trying to use
an asp page to access my Access database. I have all the security settings
on the db directory allowed so that is not the problem I am having. I had
also gotten similar errors when I was trygin to access the db while it was
also open in Access but this was not the case here and I had even restarted
the machine. I was getting this error:

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x10c Thread 0x624
DBC 0x143ca24 Jet'.

I tried swapping out the db for a copy of it and that fixed the problem
temporarily but then it poped up again. Then someone sugested that I switch
to the Jet driver instead of the ODBC one. This did fix the problem or at
least it apeared to. Then today I put the page up on our server and another
error cropped up which had the same sound at the volatile error I got from
the ODBC driver but with slightly different wording (I do not have the error
because I fixed the problem kind of). I tried swapping back to the ODBC
driver and ended up with the same error message I had the last time I used
that driver. Then I tried swapping the db out for a copy (just ctrl-c
ctrl-v not a backup copy but a literal copy) and that apears to have fixed
the problem at least for now. The problem is that I am no closer to
understanding why I am getting these error and a page that cops out and
needs to have it's db swapped out every few days is not a good thing for
obvious reasons especialy if I where to get these kind of error at
inoportune moments. If anyone has any insight into what could be going
wrong please let me know.

Thanks
Andrew

[Bob Barrows]

Stick with the Jet OLEDB Provider - switching to ODBC is not going to fix
this problem. Look at these articles (and the KB articles referenced in
them):
[url]http://www.aspfaq.com/show.asp?id=2009[/url]
[url]http://www.aspfaq.com/show.asp?id=2062[/url]

HTH,
Bob Barrows

Andrew wrote:

> I have been getting some rather confusing access errors when trying
> to use an asp page to access my Access database. I have all the
> security settings on the db directory allowed so that is not the
> problem I am having. I had also gotten similar errors when I was
> trygin to access the db while it was also open in Access but this was
> not the case here and I had even restarted the machine. I was
> getting this error:
>
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> registry key 'Temporary (volatile) Jet DSN for process 0x10c Thread
> 0x624 DBC 0x143ca24 Jet'.
>
> I tried swapping out the db for a copy of it and that fixed the
> problem temporarily but then it poped up again. Then someone
> sugested that I switch to the Jet driver instead of the ODBC one.
> This did fix the problem or at least it apeared to. Then today I put
> the page up on our server and another error cropped up which had the
> same sound at the volatile error I got from the ODBC driver but with
> slightly different wording (I do not have the error because I fixed
> the problem kind of). I tried swapping back to the ODBC driver and
> ended up with the same error message I had the last time I used that
> driver. Then I tried swapping the db out for a copy (just ctrl-c
> ctrl-v not a backup copy but a literal copy) and that apears to have
> fixed the problem at least for now. The problem is that I am no
> closer to understanding why I am getting these error and a page that
> cops out and needs to have it's db swapped out every few days is not
> a good thing for obvious reasons especialy if I where to get these
> kind of error at inoportune moments. If anyone has any insight into
> what could be going wrong please let me know.
>
> Thanks
> Andrew

[Tom Kaminski [MVP]]

"Andrew" <anagel@dot.state.ri.us> wrote in message
news:uGU$w4gSDHA.2008@TK2MSFTNGP11.phx.gbl...

> I have been getting some rather confusing access errors when trying to use
> an asp page to access my Access database. I have all the security

settings

> on the db directory allowed so that is not the problem I am having. I had
> also gotten similar errors when I was trygin to access the db while it was
> also open in Access but this was not the case here and I had even

restarted

> the machine. I was getting this error:
>
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> registry key 'Temporary (volatile) Jet DSN for process 0x10c Thread 0x624
> DBC 0x143ca24 Jet'.
>
> I tried swapping out the db for a copy of it and that fixed the problem
> temporarily but then it poped up again. Then someone sugested that I

switch

> to the Jet driver instead of the ODBC one. This did fix the problem or at
> least it apeared to. Then today I put the page up on our server and

another

> error cropped up which had the same sound at the volatile error I got from
> the ODBC driver but with slightly different wording (I do not have the

error

> because I fixed the problem kind of). I tried swapping back to the ODBC
> driver and ended up with the same error message I had the last time I used
> that driver. Then I tried swapping the db out for a copy (just ctrl-c
> ctrl-v not a backup copy but a literal copy) and that apears to have fixed
> the problem at least for now. The problem is that I am no closer to
> understanding why I am getting these error and a page that cops out and
> needs to have it's db swapped out every few days is not a good thing for
> obvious reasons especialy if I where to get these kind of error at
> inoportune moments. If anyone has any insight into what could be going
> wrong please let me know.

Start here:
[url]http://www.aspfaq.com/show.asp?id=2009[/url]

--
Tom Kaminski IIS MVP
[url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS

[url]http://mvp.support.microsoft.com/[/url]
[url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]