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

On Fri, 2 Sep 2005 04:45:02 -0700, "Neal" <Neal@xxxxxxxxxxxxxxxxxxxxxxxxx> 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.aspx?scid=kb;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/assistance/HP051882401033.aspx


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: VB-ADO Constant for varChar(size)
    ... Please specify the perfect compatible VB-ADO constant (for example ... ¤ adChar, adVarChar,adVarWChar) for the following datatypes in oracle: ... I have done a lot of search to execute a stoted procedure in Oracle ... Set adoParameter = adoCommand.CreateParameter) ...
    (microsoft.public.vb.database)
  • Re: Long Select gets truncated
    ... ¤ check the length it shows the correct size 4088. ... I think the problem is that ADO and DAO both default to Text as the data type instead of Memo. ... Apparently Microsoft Access is smart enough to determine the correct data type. ... I don't know of any way to specify the data type for the column in a SELECT statement. ...
    (microsoft.public.vb.database.dao)
  • Re: Exporting to Excel
    ... Just add another DoCmd statement and specify the other table name you are exporting. ... Paul ...
    (microsoft.public.vb.database)
  • Re: save a file in database
    ... ¤ I want to save a file in database. ... datatype for the table I should specify for storing the whole file in it. ... What type of database are you working with? ...
    (microsoft.public.dotnet.framework.adonet)
  • The Microsoft Jet database engine cannot open the file...
    ... If i don't specify a userid an pwd.. ... all permissions under admins group for the whole bang shoot and still no joy. ... Neal Rogers ...
    (microsoft.public.dotnet.framework.aspnet)