Re: Access / Security

From: Dthmtlgod (dougvandermark_at_netzero.net)
Date: 12/03/04


Date: Fri, 3 Dec 2004 10:46:06 -0500

Here is the error and connection string

The Microsoft Jet database engine cannot open the file
'\\ws\c$\inetpub\wwwroot\database\cxc.mdb'. It is already opened exclusively
by another user, or you need permission to view its data.
/cxc/missing_p.asp, line 29

27 Set Conn = Server.CreateObject("ADODB.Connection")

28 Conn.Provider = "Microsoft.Jet.OLEDB.4.0"

29 Conn.Open \\ws\c$\inetpub\wwwroot\database\cxc.mdb

"Dthmtlgod" <dougvandermark@netzero.net> wrote in message
news:uw6lm4U2EHA.3616@TK2MSFTNGP11.phx.gbl...
> No, the DB is not opened.
>
> I am using Integrated Windows authentication. All users are on Active
> Directory.
>
>
> "Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
> message news:Ot5R31U2EHA.1076@TK2MSFTNGP09.phx.gbl...
> > Is it opened exclusively by someone else?
> >
> > Does your site authenticate your users against a Windows account
database
> > (i.e. Active Directory). If so, do your users have proper NTFS
> permissions
> > on the ~directory~ in which the database resides?
> >
> > If not authenticating, does IUSR_yourServer have NTFS permissions?
> >
> > Ray at work
> >
> > "Dthmtlgod" <dougvandermark@netzero.net> wrote in message
> > news:eRXtVzU2EHA.2112@TK2MSFTNGP15.phx.gbl...
> > > OK. I have rolled out my simple ASP site, just updates a few fields
in
> a
> > > database, it works fine for administrators, but the local users are
> > getting
> > > a page can't be displayed error stating the database is opened
> exclusively
> > > (this is not the case) or they don't have rights. The database s
shared
> > to
> > > everyone as well as the actual web server.
> > >
> > > Any ideas?
> > >
> > >
> > >
> >
> >
>
>



Relevant Pages

  • OleDbException (0x80004005):
    ... The Microsoft Jet database engine cannot open the ... permission to view its data. ... dataTable, IDbCommand command, CommandBehavior behavior) ...
    (microsoft.public.vsnet.general)
  • Problem reading data from Access 2000
    ... Jet database engine cannot open the file ''. ... SQLSetConnectAttr failed ERROR [ODBC Microsoft Access ... Driver] The Microsoft Jet database engine cannot open the file ... need permission to view its data. ...
    (microsoft.public.dotnet.framework.adonet)
  • Access and database connection
    ... The Microsoft Jet database engine cannot open the ... or you need permission ... group Administrators, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: error insert from asp to access
    ... Microsoft JET Database Engine ... the folder is under wwwroot with asp file and mdb file. ... Is there something with permission and LDB? ...
    (microsoft.public.inetserver.asp.db)
  • DTS error -2147467259
    ... It works great if I run the package manually. ... Error source: Microsoft JET Database Engine ... DTSRun OnStart: Copy Data from Results to Results Step ...
    (microsoft.public.sqlserver.dts)