all groups > vb.net data > april 2004 >
You're in the

vb.net data

group:

Jet Won't Open


Jet Won't Open Curt Emich
4/22/2004 12:52:46 AM
vb.net data:
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?

Re: Jet Won't Open William Ryan eMVP
4/22/2004 1:15:14 AM
Hi Curt:
[quoted text, click to view]

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
[quoted text, click to view]

Re: Jet Won't Open Curt Emich
4/22/2004 11:04:36 PM
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.


[quoted text, click to view]

Re: Jet Won't Open William Ryan eMVP
4/23/2004 2:17:14 AM
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
[quoted text, click to view]

AddThis Social Bookmark Button