MS Access read only error

[Burt Rosner]

To anyone,

I have a new laptop with Windows 2000 Pro. I want to use
it as my web server. I installed IIS and Microsoft
FrontPage Server Extension 2002. I created the web folder
and copied my pages into it. I created the pages with
FrontPage XP using an MS Access XP mdb. Then I perform
the publish routine in FrontPage. When I when to the web-
site and brought up the first page everything looked
good. When I entered data and clicked submit I got an
error telling me the MS Access mdb was read only. So I
created another MS Access mdb and imported the tables from
the "read only": mdb. Then I renamed the new mdb to the
same name. Then I replace the original mdb with the new
one and performed the published routine. When I went to
the web site I got the same error "read only".

Could someone tell me why that happened? and how I might
correct this?

Thanks,

Burt

 

[Steve Easton]

Can you just change the mdb files attributes
using Windows Explorer??

 

[Mike Mueller]

I think I may have the same issue. This all started after I
got the FPSE operational. Windows explorer shows it as not
read only, and the everyone & guest accounts have read /
write permissions. Here is the error I receive:

Cannot update the database
Error Description: [Microsoft][ODBC Microsoft Access Driver]
Cannot update. Database or object is read-only.

Error Number: -2147467259

Error Source: Microsoft OLE DB Provider for ODBC Drivers



: Can you just change the mdb files attributes
: using Windows Explorer??
:
:
:: To anyone,
::
:: I have a new laptop with Windows 2000 Pro. I want to use
:: it as my web server. I installed IIS and Microsoft
:: FrontPage Server Extension 2002. I created the web
:: folder and copied my pages into it. I created the pages
:: with FrontPage XP using an MS Access XP mdb. Then I
:: perform the publish routine in FrontPage. When I when
:: to the web- site and brought up the first page
:: everything looked good. When I entered data and clicked
:: submit I got an error telling me the MS Access mdb was
:: read only. So I created another MS Access mdb and
:: imported the tables from the "read only": mdb. Then I
:: renamed the new mdb to the same name. Then I replace
:: the original mdb with the new one and performed the
:: published routine. When I went to the web site I got
:: the same error "read only".
::
:: Could someone tell me why that happened? and how I might
:: correct this?
::
:: Thanks,
::
:: Burt

 

[Steve Easton]

Not that familiar with IIS, but wouldn't that
be a permissions setting set via the server control panel??

 

[Jim Buyens]

You need to grant Change permissions to the entire folder
that contains an Access database, and not just to the .mdb
file. This is because Access needs to create and
delete .lck files in the same folder as the database.

You can avoid most permission problems by setting up a
FrontPage database connection to your database, even if
you don't plan to use the FrontPage connection. This will
set the correct permissions on the database folder, and
mark the FrontPage as an IIS application as well.

Choose Web Settings from the Tools menu, and then click
the Database tab.

BTW, don't forget to mark the database folder as non-
browsable. Right-click it in the Folder list or Folder
view, choose Properties, and clear Allow Files To Be
Browsed. This has no effect on local server operations,
but it stops curious visitors and bad guys from
downloading your database.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

 

[Burt Rosner]

Steve,

Thanks. I thought that was OK, but will check again.

Burt

-----Original Message-----
Not that familiar with IIS, but wouldn't that
be a permissions setting set via the server control panel??

--
95isalive
This site is best viewed..................
...............................with a computer

I think I may have the same issue. This all started after I
got the FPSE operational. Windows explorer shows it as not
read only, and the everyone & guest accounts have read /
write permissions. Here is the error I receive:

Cannot update the database
Error Description: [Microsoft][ODBC Microsoft Access Driver]
Cannot update. Database or object is read-only.

Error Number: -2147467259

Error Source: Microsoft OLE DB Provider for ODBC Drivers



: Can you just change the mdb files attributes
: using Windows Explorer??
:
:
:: To anyone,
::
:: I have a new laptop with Windows 2000 Pro. I want to use
:: it as my web server. I installed IIS and Microsoft
:: FrontPage Server Extension 2002. I created the web
:: folder and copied my pages into it. I created the pages
:: with FrontPage XP using an MS Access XP mdb. Then I
:: perform the publish routine in FrontPage. When I when
:: to the web- site and brought up the first page
:: everything looked good. When I entered data and clicked
:: submit I got an error telling me the MS Access mdb was
:: read only. So I created another MS Access mdb and
:: imported the tables from the "read only": mdb. Then I
:: renamed the new mdb to the same name. Then I replace
:: the original mdb with the new one and performed the
:: published routine. When I went to the web site I got
:: the same error "read only".
::
:: Could someone tell me why that happened? and how I might
:: correct this?
::
:: Thanks,
::
:: Burt

.

 

[Burt Rosner]

Mike,

Thanks for the input. I don't feel along now. It's not
clear how you corrected it.

Thanks again,

Burt

 

[Guest]

Steve,

I believe I did it, but will try again.

Thanks,

Burt

 

[Cheryl D. Wise]

Open Administrative Tools, Internet Information Server and expand the
default web site folder list until you see the folder that contains your
Access database. Right click and select properties then put a check mark in
the write box on the Directory page.

When you access the database through http://localhost it looks to the
permissions set on the web server not just those on the file system.

You can set write permissions on a file by file basis but most
administrators enable one folder per web for all objects that need write
permissions.