.NETGURU
  Search:  
NamespacesDiscussions.NET v1.1Dot Net Guru's BlogIT Certification
Jet Won't Open
Messages   Related Types
This message was discovered on microsoft.public.dotnet.framework.odbcnet.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.
Post a new message to this list...

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?
Reply to this message...
 
    
William Ryan eMVP (VIP)
Hi Curt:
"Curt Emich" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
> 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.dot-net-guru.com/247reference/msgs/13/68136.aspx
[Original message clipped]
Reply to this message...
 
    
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" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]
Reply to this message...
 
    
Curt Emich
CORRECTION: I tried everything BUT giving full permissions to the
"everyone" user in the security group. That did the trick.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply to this message...
 
    
William Ryan eMVP (VIP)
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" <Click here to reveal e-mail address> wrote in message
news:Click here to reveal e-mail address...
[Original message clipped]
Reply to this message...
 
 
System.Data.Common.DataAdapter




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification