Updateable query!
From: bol (bol.1jqaif_at_mail.codecomments.com)
Date: 01/31/05
- Next message: flex: "New Cracked Software(cad,cae,cam,eda,pcb,gis,cfd,cnc...)"
- Previous message: Toska: "Add markup code to specific words in a text"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 31 Jan 2005 07:49:11 -0600
Hi Gregory
Thanks for the response.
Some of our staff work from home and normally log in to our database
from home. Thus there are already set up in a group called
authenticated users. They log into to a page which allows them to
choose what they want to access, i.e. database or extranet. If they
want to access the extranet, another login page comes up which they
have to log into before reaching the extranet.
I used the Securelogin Manager application to set this up.
bol
Cowboy (Gregory A. Beamer) - MVP wrote:
> *ASP or ASP.NET? Subtle word change, but a potential world of
> difference in
> solution.
>
> The issue here, as stated, is the type of cursor. By default, an ADO
> connetion (ASP world) is a firehose cursor (fast-forward only). To
> conquer
> the error, you change cursor types.
>
> Not so fast, however, as 80004005 is, unfortunately, a rather generic
> error
> and the messages thrown are not always correct. Thus, the first thing
> I would
> look at, based on the "it works here, not here" scenario, is whether
> or not
> the logged in user has access to the directory the .mdb file sits in.
> With
> Access, the user using the database has to have write ability in the
> directory to create a lock (.ldb) file.
>
> Q: What user is using the application?
> A: If you are using a windows login (to the web app - will pop up a
> login
> box unless the network is set to avoid this), then you need to add
> the users
> to a domain group and give that group rights to the directory. If you
> have
> anonymous access on in the app, you are most likely running users
> under the
> IUSR account, so give it read/write access to the .mdb file and
> directory.
>
> ---
>
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ***************************
> Think Outside the Box!
> ***************************
>
> "bol" wrote:
>
> >
> > I am trying to get our extranet site working, i.e. login page. It
> seemed
> > to work on my site and our internal intranet server but it's not
> working
> > on the main webserver which our out of house staff use to log in.
> >
> > I keep on getting this message -
> >
> > Microsoft JET database engine error '80004005'
> > Operation must use an updateble query.
> >
> > It then points to line 34 in a .asp file which I have checked over
> and
> > over again.
> >
> > I have changed all the permissions on the root folder which then
> > changes all the folders under it to write, read and execute to a
> group
> > called authenticated users (staff that have to log in) but I still
> get
> > this message. Does anybody know what else I can do apart from
> changing
> > the permissions settings?
> >
> > Thanks in advance.
> >
> > Bol
> >
> >
> >
> > --
> > bol
> >
> ------------------------------------------------------------------------
> > Posted via [url]http://www.codecomments.com[/url]
> >
> ------------------------------------------------------------------------
> >
> > *
-- bol ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------
- Next message: flex: "New Cracked Software(cad,cae,cam,eda,pcb,gis,cfd,cnc...)"
- Previous message: Toska: "Add markup code to specific words in a text"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
