Readonly Database Objects??

[Roy Chastain]

I have a problem that I have caused more than once in the last 2 weeks
I have a working Access database that is being queried and updated via
web site.

I have copied that database to another website (copied by Copy/Past in
FrontPage). I have setup connections etc. Can access the database
for query just fine. However, the same code that will update the
database on the old site fails on the new site with the following.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object is read-only.

/ServerScripts/Countermaintenance.asp, line 87


Since I have managed to do this to 3 different databases in the last 2
weeks, I figure that I am doing something wrong.
1) - What is it.
2) - What is the correct method of copying/moving a Access Database
from one web to another
3) - Is there anyway to fix the 'read-only' database?

BTW. I have checked the file properties of the .mdb file and they are
NOT read-only.
The error occurs on any function that tries to update the recordset.

Thanks
-------------------------------------------
Roy Chastain

[Kris Eiben]

Not read-only for who? IIRC, IIS runs in the context of the IUSR. And
you may want to check the permissions on the folder as well as the file.

"Roy Chastain" <roy@roychastain.orgnospam> wrote in message
news:kv0n30ph4f2n92pps5cil4i2lifdkl8535@4ax.com...

> I have a problem that I have caused more than once in the last 2 weeks
> I have a working Access database that is being queried and updated via
> web site.
>
> I have copied that database to another website (copied by Copy/Past in
> FrontPage). I have setup connections etc. Can access the database
> for query just fine. However, the same code that will update the
> database on the old site fails on the new site with the following.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
> object is read-only.
>
> /ServerScripts/Countermaintenance.asp, line 87
>
>
> Since I have managed to do this to 3 different databases in the last 2
> weeks, I figure that I am doing something wrong.
> 1) - What is it.
> 2) - What is the correct method of copying/moving a Access Database
> from one web to another
> 3) - Is there anyway to fix the 'read-only' database?
>
> BTW. I have checked the file properties of the .mdb file and they are
> NOT read-only.
> The error occurs on any function that tries to update the recordset.
>
> Thanks
> -------------------------------------------
> Roy Chastain

[Roy Chastain]

I have 2 .mdb files in the fpdb directory. One was created into that
directory by Access and I can write to it via ASP. The other was
copied and it is read-only to ASP. Both files are marked Read/Write
for IUSR. Oddies that I need to chase down/get an explanation for is
that
1) - The copied file claims that its permissions are inherited while
the created file is not.
2) - The copied file has security entries for _Web Applications and
_Web Anonymous Users. I have never seen these two groups before.
They both have DENY write set on the copied file. Who can explain
where these two groups come from and how they got set on this file?

On Tue, 24 Feb 2004 13:08:32 -0500, "Kris Eiben"
<eibenkthisisforspammers@yahoo.com> wrote:

>Not read-only for who? IIRC, IIS runs in the context of the IUSR. And
>you may want to check the permissions on the folder as well as the file.
>

-------------------------------------------
Roy Chastain