Re: Accessing Jet Engines in Asp. Please help - A critical deadline is closing in.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Roger Stenson (roger.stenson1_at_ntlworld.com)
Date: 03/08/04 

Date: Mon, 8 Mar 2004 11:20:44 -0000

Thank you both very much. Sorting out the permissions on the database plus
checking the Windows permissions and sharing seem to have done the trick
I have a supplementary question. I have built a WorkGroup Admin file in the
same folder as the databases and it contains the permissions you recommend
for all the machines I put the database on.
Am I correct in assuming the Work Group database is mainly instrumental in
supporting the administrator and is not used at run time.
Otherwise I don't think I understand why the solution has worked because
when I upload the database to IIS on the Internet Host the absolute address
for fthe mdw stored in the database is not aligned with the directory used
by my application in this environment.
If my hypotheses is correct I don't need to post a copy of the mdw file to
the web hose

Roger Stenson
"dan artuso" <dan.artuso@NOSPAMnrc.ca> wrote in message
news:%23rI1If4AEHA.2480@TK2MSFTNGP11.phx.gbl...
> Hi,
> Just a thought, are the permissions the same on both machines on the
> directory
> where the database is located?
>
> Dan Artuso, MVP
>
> "Roger Stenson" <roger.stenson1@ntlworld.com> wrote in message
> news:uYPY$2tAEHA.2404@TK2MSFTNGP11.phx.gbl...
> > Hi
> > I have a web ASP application using Access 2000 format databases which I
> > developed in vb script on Windows 2000. The product works fine on IIS
> > in the development machine and was fairly widely used for customer
> > demonstration
> > system with limited db's in a trial ISP using NT4.
> >
> > The web product is supported by a back-office vb6 system used to build
> the
> > database for real. The database is now ready and the client wishes to
go
> > live on the web
> >
> > When we run the proven asp code on IIS in an XP Pro machine with the new
> > databases, it immediatly halts with the browser displaying a message
from
> > the Jet Microsoft JET Database Engine "(0x80040E09) Cannot update.
> Database
> > or object is read-only." We get the the same message when we upload th
e
> > system and data to the chosen ISP who also uses NT4.
> > The database complained of is the "System database " which has already
> been
> > read from by
> > global.asa on start up. The system fails on an 'Addnew' instruction
when
> > adding a log- in to the log file.
> >
> > I have spent a lot of time pouring over ACCESS security texts and have
> three
> > versions of the database, one unsecured, one secured with all the update
> > functions cleared for use by everyone and one imported from the working
> > Windows 2k environment.
> > All three work fine in the Windows 2k IIS and with the back office VB
> > system. All three achieve the above error
> > when running on IIS on the XP machine and when uploaded to the new ISP.
> >
> > As the ASP vb script specifically opens the Ado connection in read write
> > mode and
> > has long been working, we can't believe it is the Asp code that is the
> > problem.
> >
> > So I have recently spent some time comparing the IIS setups in W2k and
> XPPro
> > machines but can not find any differneces which look material to me. I
> > would be really grateful for some ideas on how to move this problem
> forward
> > or how to set
> > about furthering the diagnosis. as I am at my wits end.
> >
> > Roger Stenson
> >
> >
> >
>
>

Relevant Pages

  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)
  • Re: Active directory corruption
    ... During an installation of PHP I accidentally changed permissions for the ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.sbs)
  • Re: Active directory corruption
    ... default web site and copied the permissions to all the child ... as it may not be the database that is the problem. ... prompt, use the ESENTUTL to check the integrity of the database. ... To recover the database type the following at the command prompt: ...
    (microsoft.public.windows.server.sbs)
  • Re: Design view (select query with link table issues)
    ... but they do not work on some user's machines? ... you try to open the table directly in the database window, ... you are talking about a query that draws from tables that are not ... >> permissions, Windows user permissions, or file-share permissions. ...
    (microsoft.public.access.queries)