Updateable query!

[bol]

Hi Gregory

Thanks for the response.

Some of our staff work from home and normally log in to our databas
from home. Thus there are already set up in a group calle
authenticated users. They log into to a page which allows them t
choose what they want to access, i.e. database or extranet. If the
want to access the extranet, another login page comes up which the
have to log into before reaching the extranet.

I used the Securelogin Manager application to set this up.

bol

*ASP or ASP.NET? Subtle word change, but a potential world o
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). T
conquer
the error, you change cursor types.

Not so fast, however, as 80004005 is, unfortunately, a rather generi
error
and the messages thrown are not always correct. Thus, the first thin
I would
look at, based on the "it works here, not here" scenario, is whethe
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
login
box unless the network is set to avoid this), then you need to ad
the users
to a domain group and give that group rights to the directory. If yo
have
anonymous access on in the app, you are most likely running user
under the
IUSR account, so give it read/write access to the .mdb file an
directory.

---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

-
bo