Re: MSAccess Permision problem PLEASE HELP.

From: george d lake (georgel@valleyyellowpages.com)
Date: 10/15/02 

From: "george d lake" <georgel@valleyyellowpages.com>
Date: Tue, 15 Oct 2002 09:18:50 -0700

I cant use a Generic "WebUser" in the DB? Because there might be 100s of
potential users, I cant create a NT account for each one.
I dream of SQL Server.

"Helen Warn" <hwarn@shaw.ca> wrote in message
news:#$t3JVGdCHA.776@tkmsftngp08...
> I believe that you will have to add yourself (or any user you want to be
> able to read the tables) to the users of the Access database and give them
> appropriate permissions. If it has its own security file (*.mdw) you will
> have to edit it.
>
> hth
>
> Helen
>
> "george d lake" <georgel@valleyyellowpages.com> wrote in message
> news:OHifE9FdCHA.1652@tkmsftngp09...
> > Ok, I have been stuck in the mud for 3 weeks now with this.
> > I have an access database that has users, usergroups and passwords. I am
> > using ASP.NET
> > I can only get access to the tables if I login as georgel in the network
> and
> > login on my box (same as the webServer)
> > If I login as someone else or login on a diferrent workstation or have
> some
> > else form thiere PC access the page it does not work.
> > I changed the loginID for the database form georgel to WebUser (created
> all
> > the permisiones etc) and same thing.
> > Here is some code
> > Any ideas, sugestion or fixes will be VERY MUCH APPRECIATED!
> >
> > Code:
> >
> > Dim strConnectionString As String
> > Private oConn As OleDbConnection
> > Dim oCmd As OleDbCommand
> > Private pDBDR As OleDbDataReader
> >
> >
> > strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;User
> > ID=WebUser;Data Source=M:\BlankMarketing.mdb;Jet OLEDB:System
> > database=m:\secured.mdw;"
> > oConn = New OleDbConnection(strConnectionString)
> > oCmd = New OleDbCommand(pstrSQL, oConn)
> > oCmd.CommandType = CommandType.Text
> >
> > Try
> > pErrorDescription = ""
> > pErrorCode = 0
> > oConn.Open() *******LINE
213*************
> > pDBDR = oCmd.ExecuteReader
> > Catch oError As System.Exception
> > pErrorDescription = Err.Description
> > pErrorCode = Err.Number
> > Call WriteEventLog(oError)
> > Finally
> >
> >
> > Error:
> > Message : The Microsoft Jet database engine cannot open the file ''. It
> is
> > already opened exclusively by another user, or you need permission to
view
> > its data.
> > Source : Microsoft JET Database Engine
> > StackTrace : at
System.Data.OleDb.OleDbConnection.ProcessResults(Int32
> > hr)
> > at System.Data.OleDb.OleDbConnection.InitializeProvider()
> > at System.Data.OleDb.OleDbConnection.Open()
> > at VYPFCv2.cDB.GetSQLQuery() in C:\Documents and Settings\georgel\My
> > Documents\Visual Studio Projects\VYPFCv2\dbAccess.vb:line 213
> > NT User :travisa
> >
> >
>
>

Relevant Pages

  • Best Way to Change Password via the Web?
    ... remote users who use OWA and other web services here that require a NT login ... I plan on using the IISAdmPwd .htr files ... against my Access database they are forwarded on to the IISAdmPwd login ...
    (microsoft.public.windows.server.security)
  • Best Way to Change Password via the Web?
    ... remote users who use OWA and other web services here that require a NT login ... I plan on using the IISAdmPwd .htr files ... against my Access database they are forwarded on to the IISAdmPwd login ...
    (microsoft.public.inetserver.iis.security)
  • Best Way to Change Password via the Web?
    ... remote users who use OWA and other web services here that require a NT login ... I plan on using the IISAdmPwd .htr files ... against my Access database they are forwarded on to the IISAdmPwd login ...
    (microsoft.public.win2000.security)
  • Re: so strange
    ... >The problem is that i can login to yahoo messenger but i ... >webcam and i cant login to msn messenger and i cant open ... firewall, but, for instance, Zone Alarm needs to be at "medium" for my webcam ...
    (microsoft.public.windowsxp.general)
  • Re: Password Expired Chnage Password form
    ... Cant you set the password policy on AD? ... > Because if the users password has expired and they try to login, ... >> Space Junk wrote: ... >>> Does anyone know if there is a change password form, like in OWA, ...
    (microsoft.public.sharepoint.portalserver)