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.mdb'. 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:

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.aspx?scid=kb;EN-US;306269
http://www.dotnet247.com/247reference/msgs/13/68136.aspx

 

[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]

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