Configuring permissions for write/modify access for a database
on the server.
With FrontPage you can
configure the correct database access and security settings
needed for most database driven Active Server Page applications.
These include:
- Shopping carts such as
StoreFront or SalesCart
- ASPLogin
- Any other database that
runs with ASP on your site.
If your database permissions
have not been set, the following error may occur:
Microsoft OLE DB Provider for
ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use
an updateable query.
This is easily fixed by
setting up a database connection by following the steps
exactly as outlined below: SET UP
WRITE ACCESS TO YOUR DATABASE ON THE SERVER
- Open your Internet web
site with FrontPage
(This is the site that resides on your hosting account on an
Acme Internet web server, not on your computer)
- Click TOOLS -> WEB
SETTINGS -> DATABASE
- Click ADD
Leave the default name that appears in the Name Field as-is
- Click "FILE OR FOLDER
IN CURRENT WEB"
(even if your have a System DSN on the server - still choose
the 'File or Folder' option because that's where you want
the permissions to be applied)
- Click BROWSE
Select the appropriate yourdatabase.mdb file in your /fpdb
folder and click OK
- CLICK OK again to
create the new database connection
You will now see your new database connection listed in the
database tab of the 'Web Settings' menu with a ? Question
Mark next to it
- Select your new
database connection and CLICK VERIFY
- CLICK OK to finish and
exit the 'Web Settings' menu
|