Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > The Microsoft Jet database engine cannot open the file...

Reply
Thread Tools

The Microsoft Jet database engine cannot open the file...

 
 
=?Utf-8?B?TmVhbA==?=
Guest
Posts: n/a
 
      09-02-2005
Hi All

I am trying to connect from ASP.Net app to an Access Db.
If i don't specify a userid an pwd.. I get this error

The Microsoft Jet database engine cannot open the file 'C:\Documents and
Settings\rogersn\My Documents\EEECourses.mdb'. It is already opened
exclusively by another user, or you need permission to view its data."

If i specify a userid (aspnet) no password I get

Cannot start your application. The workgroup information file is missing or
opened exclusively by another user

If I specify any other mdb on my machine...
NO Problem...???


I have subsequently used the mdw file, joined it , created an aspnet user,
all permissions under admins group for the whole bang shoot and still no joy.
??

Then used the permissions wizard and now all my db's pop up a login dialog,
which I really don't want and finding documentation on this especially
removing that is like expecting a miracle..

ie
Q1 How do Iresolve these errors on one mdb only (Access 2000, on Xp sp2
OS)and connect to the db
Q2 How do I get rid of the whole permissions, / login screen security.

TIA
Neal

--
Neal Rogers
University of Cape Town
 
Reply With Quote
 
 
 
 
Coldman
Guest
Posts: n/a
 
      09-02-2005
maybe the user used by asp.net dont have access to the folder 'C:\Documents
and
Settings\rogersn\My Documents\
try moving the mdb to another location

"Neal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All
>
> I am trying to connect from ASP.Net app to an Access Db.
> If i don't specify a userid an pwd.. I get this error
>
> The Microsoft Jet database engine cannot open the file 'C:\Documents and
> Settings\rogersn\My Documents\EEECourses.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data."
>
> If i specify a userid (aspnet) no password I get
>
> Cannot start your application. The workgroup information file is missing
> or
> opened exclusively by another user
>
> If I specify any other mdb on my machine...
> NO Problem...???
>
>
> I have subsequently used the mdw file, joined it , created an aspnet user,
> all permissions under admins group for the whole bang shoot and still no
> joy.
> ??
>
> Then used the permissions wizard and now all my db's pop up a login
> dialog,
> which I really don't want and finding documentation on this especially
> removing that is like expecting a miracle..
>
> ie
> Q1 How do Iresolve these errors on one mdb only (Access 2000, on Xp sp2
> OS)and connect to the db
> Q2 How do I get rid of the whole permissions, / login screen security.
>
> TIA
> Neal
>
> --
> Neal Rogers
> University of Cape Town



 
Reply With Quote
 
 
 
 
Juan T. Llibre
Guest
Posts: n/a
 
      09-02-2005
Neal, what does your connection string look like ?

If you're using an mdw file, it should look like :


"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System
Database=system.mdw;"

Bookmark this page : http://www.connectionstrings.com/
and check the connection string variations for Access MDB's.




Juan T. Llibre
ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
=============================

"Neal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi All
>
> I am trying to connect from ASP.Net app to an Access Db.
> If i don't specify a userid an pwd.. I get this error
>
> The Microsoft Jet database engine cannot open the file 'C:\Documents and
> Settings\rogersn\My Documents\EEECourses.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data."
>
> If i specify a userid (aspnet) no password I get
>
> Cannot start your application. The workgroup information file is missing or
> opened exclusively by another user
>
> If I specify any other mdb on my machine...
> NO Problem...???
>
>
> I have subsequently used the mdw file, joined it , created an aspnet user,
> all permissions under admins group for the whole bang shoot and still no joy.
> ??
>
> Then used the permissions wizard and now all my db's pop up a login dialog,
> which I really don't want and finding documentation on this especially
> removing that is like expecting a miracle..
>
> ie
> Q1 How do Iresolve these errors on one mdb only (Access 2000, on Xp sp2
> OS)and connect to the db
> Q2 How do I get rid of the whole permissions, / login screen security.
>
> TIA
> Neal
>
> --
> Neal Rogers
> University of Cape Town



 
Reply With Quote
 
Paul Clement
Guest
Posts: n/a
 
      09-02-2005
On Fri, 2 Sep 2005 04:45:02 -0700, "Neal" <(E-Mail Removed)> wrote:

Hi All

I am trying to connect from ASP.Net app to an Access Db.
If i don't specify a userid an pwd.. I get this error

The Microsoft Jet database engine cannot open the file 'C:\Documents and
Settings\rogersn\My Documents\EEECourses.mdb'. It is already opened
exclusively by another user, or you need permission to view its data."


This is a resource permissions problem. It has nothing to do with user-level security. See the
following:

http://support.microsoft.com/default...b;en-us;316675

If i specify a userid (aspnet) no password I get

Cannot start your application. The workgroup information file is missing or
opened exclusively by another user

If I specify any other mdb on my machine...
NO Problem...???


I have subsequently used the mdw file, joined it , created an aspnet user,
all permissions under admins group for the whole bang shoot and still no joy.
??

Then used the permissions wizard and now all my db's pop up a login dialog,
which I really don't want and finding documentation on this especially
removing that is like expecting a miracle..

Did you actually configure this database for user-level security? If so see the following to remove
it:

Remove user-level security (MDB)
http://office.microsoft.com/en-us/as...882401033.aspx


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-30-2006 03:16 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 1 03-24-2006 04:20 PM
ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x8fc Thread 0x934 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr bazzer ASP .Net 0 03-24-2006 02:22 PM
The Microsoft Jet database engine cannot open the file Morten Wennevik ASP .Net 1 10-31-2005 11:18 AM
The Microsoft Jet database engine cannot open the file =?Utf-8?B?RGF2ZQ==?= ASP .Net 6 08-05-2005 01:06 PM



Advertisments