Jet Won't Open

[Curt Emich]

I get the following error when I write any code against a connection that is
hooked to an Access database:
The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.m db'. It is already opened
exclusively by another user, or you need permission to view its data.
Does anyone have any idea what to do about this?

[William Ryan eMVP]

Hi Curt:
"Curt Emich" <ce****@comcast.net> wrote in message
news:C9********************@comcast.com...

I get the following error when I write any code against a connection that is hooked to an Access database:
First, can you open the DB manually? If not then the problem is much more
serious. If you can then check out this KB Article:\

http://support.microsoft.com/default...b;EN-US;306269
http://www.dotnet247.com/247referenc.../13/68136.aspx

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.m db'. It is already opened exclusively by another user, or you need permission to view its data.
Does anyone have any idea what to do about this?

[William Ryan eMVP]

Hi Curt:
"Curt Emich" <ce****@comcast.net> wrote in message
news:C9********************@comcast.com...

I get the following error when I write any code against a connection that is hooked to an Access database:
First, can you open the DB manually? If not then the problem is much more
serious. If you can then check out this KB Article:\

http://support.microsoft.com/default...b;EN-US;306269
http://www.dotnet247.com/247referenc.../13/68136.aspx

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.m db'. It is already opened exclusively by another user, or you need permission to view its data.
Does anyone have any idea what to do about this?

[Curt Emich]

Auuuughhh! I've tried everything suggested in this message and anything
related I can find on Google, but STILL I can't open Access from .NET to
save my life!!

Maybe the suicide rate among programmers would drop a little if we all just
acknolwedge that Acess CANNOT be used from .NET. Thanks for trying.
"William Ryan eMVP" <bi**@NoSp4m.devbuzz.com> wrote in message
news:Oe**************@TK2MSFTNGP11.phx.gbl...

Hi Curt:
"Curt Emich" <ce****@comcast.net> wrote in message
news:C9********************@comcast.com...

I get the following error when I write any code against a connection

that is

hooked to an Access database:

First, can you open the DB manually? If not then the problem is much more
serious. If you can then check out this KB Article:\

http://support.microsoft.com/default...b;EN-US;306269
http://www.dotnet247.com/247referenc.../13/68136.aspx

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.m db'. It is already

opened

exclusively by another user, or you need permission to view its data.
Does anyone have any idea what to do about this?

[Curt Emich]

Auuuughhh! I've tried everything suggested in this message and anything
related I can find on Google, but STILL I can't open Access from .NET to
save my life!!

Maybe the suicide rate among programmers would drop a little if we all just
acknolwedge that Acess CANNOT be used from .NET. Thanks for trying.
"William Ryan eMVP" <bi**@NoSp4m.devbuzz.com> wrote in message
news:Oe**************@TK2MSFTNGP11.phx.gbl...

Hi Curt:
"Curt Emich" <ce****@comcast.net> wrote in message
news:C9********************@comcast.com...

I get the following error when I write any code against a connection

that is

hooked to an Access database:

First, can you open the DB manually? If not then the problem is much more
serious. If you can then check out this KB Article:\

http://support.microsoft.com/default...b;EN-US;306269
http://www.dotnet247.com/247referenc.../13/68136.aspx

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.m db'. It is already

opened

exclusively by another user, or you need permission to view its data.
Does anyone have any idea what to do about this?

[William Ryan eMVP]

Hi Curt:

Access can definitely be used from .NET ;-). Have you verified that you an
open it manually? If so, then create copy the Db to your local machine to
like the C:\ drive and create a desktop app. Then use the DataAdapter
connection wizard, it will ask you for a connection, set it up to point ot
the local file on C and test the connection. It should connect. If it does,
then it's most likely a permission problem. If not, then the DB is the
problem, maybe its corrupted (although if you can open it manually then it's
not a corruption).

Let me know.

Bill
"Curt Emich" <ce****@comcast.net> wrote in message
news:wJ********************@comcast.com...

Auuuughhh! I've tried everything suggested in this message and anything
related I can find on Google, but STILL I can't open Access from .NET to
save my life!!

Maybe the suicide rate among programmers would drop a little if we all just acknolwedge that Acess CANNOT be used from .NET. Thanks for trying.
"William Ryan eMVP" <bi**@NoSp4m.devbuzz.com> wrote in message
news:Oe**************@TK2MSFTNGP11.phx.gbl...

Hi Curt:
"Curt Emich" <ce****@comcast.net> wrote in message
news:C9********************@comcast.com...

I get the following error when I write any code against a connection that

is

hooked to an Access database:

First, can you open the DB manually? If not then the problem is much

more serious. If you can then check out this KB Article:\

http://support.microsoft.com/default...b;EN-US;306269
http://www.dotnet247.com/247referenc.../13/68136.aspx

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.m db'. It is already

opened

exclusively by another user, or you need permission to view its data.
Does anyone have any idea what to do about this?

[William Ryan eMVP]

Hi Curt:

Access can definitely be used from .NET ;-). Have you verified that you an
open it manually? If so, then create copy the Db to your local machine to
like the C:\ drive and create a desktop app. Then use the DataAdapter
connection wizard, it will ask you for a connection, set it up to point ot
the local file on C and test the connection. It should connect. If it does,
then it's most likely a permission problem. If not, then the DB is the
problem, maybe its corrupted (although if you can open it manually then it's
not a corruption).

Let me know.

Bill
"Curt Emich" <ce****@comcast.net> wrote in message
news:wJ********************@comcast.com...

Auuuughhh! I've tried everything suggested in this message and anything
related I can find on Google, but STILL I can't open Access from .NET to
save my life!!

Maybe the suicide rate among programmers would drop a little if we all just acknolwedge that Acess CANNOT be used from .NET. Thanks for trying.
"William Ryan eMVP" <bi**@NoSp4m.devbuzz.com> wrote in message
news:Oe**************@TK2MSFTNGP11.phx.gbl...

Hi Curt:
"Curt Emich" <ce****@comcast.net> wrote in message
news:C9********************@comcast.com...

I get the following error when I write any code against a connection that

is

hooked to an Access database:

First, can you open the DB manually? If not then the problem is much

more serious. If you can then check out this KB Article:\

http://support.microsoft.com/default...b;EN-US;306269
http://www.dotnet247.com/247referenc.../13/68136.aspx

The Microsoft Jet database engine cannot open the file
'C:\Inetpub\wwwroot\TimeTracker\Data\TimeTracker.m db'. It is already

opened

exclusively by another user, or you need permission to view its data.
Does anyone have any idea what to do about this?