Re: MSAccess Permision problem PLEASE HELP.

From: Helen Warn (hwarn@shaw.ca)
Date: 10/15/02


From: "Helen Warn" <hwarn@shaw.ca>
Date: Tue, 15 Oct 2002 10:11:13 -0700


IIRC, you can unprotect the database (if you have the appropriate access to
get into it to do so). I believe that should solve the problem. I haven't
had to program in Access for years (thank heavens!) so I am a bit rusty as
to the details.

Good luck!

Helen

"george d lake" <georgel@valleyyellowpages.com> wrote in message
news:OW3LfZGdCHA.1864@tkmsftngp11...
> 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
> > >
> > >
> >
> >
>
>