For Programmers: Free Programming Magazines  


Home > Archive > ASP .NET > September 2005 > Error opening AccessDB from the newly spawned thread









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Error opening AccessDB from the newly spawned thread
alex444

2005-09-28, 9:57 pm

Hi all,
I'm getting the following exception when trying to open an Access DB from
the new thread:

The Microsoft Jet database engine cannot open the file
'\\path\errorLog.mdb'. It is already opened exclusively by another user, or
you need permission to view its data.

The point is that the main thread can access that file no trouble at all
(hence it's coded that only a spawned thread should do this).
Apparantly some extra permissions should be granted but not sure.

Thanks
Landley

2005-09-29, 7:57 am

If your web app can access it, you should not need anymore permission
setting.

What is your main thread doing with the database at the point of which you
attempt to open a second connection?

Landers

"alex444" <alex444@discussions.microsoft.com> wrote in message
news:6848E69D-3BC4-4157-8715-0188F0C137D2@microsoft.com...
> Hi all,
> I'm getting the following exception when trying to open an Access DB from
> the new thread:
>
> The Microsoft Jet database engine cannot open the file
> '\\path\errorLog.mdb'. It is already opened exclusively by another user,

or
> you need permission to view its data.
>
> The point is that the main thread can access that file no trouble at all
> (hence it's coded that only a spawned thread should do this).
> Apparantly some extra permissions should be granted but not sure.
>
> Thanks



alex444

2005-09-29, 7:01 pm

Trying to localize the problem (which is hard to do on the provider's host
and as I said everything working fine on my dev box) I've dedicated one
access DB to be opened only from a new thread (this is where it fails), but
when I change the code to open that DB from the main thread it just works
fine.

Thank you


"Landley" wrote:

> If your web app can access it, you should not need anymore permission
> setting.
>
> What is your main thread doing with the database at the point of which you
> attempt to open a second connection?
>
> Landers
>
> "alex444" <alex444@discussions.microsoft.com> wrote in message
> news:6848E69D-3BC4-4157-8715-0188F0C137D2@microsoft.com...
> or
>
>
>

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2010 codecomments.com