Home
Up
ODBC Connections
File DSN's
System DSNs
DB Permissions

 

 

 How To FAQs   

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:

  1. Shopping carts such as StoreFront or SalesCart
  2. ASPLogin
  3. 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

  1. 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)
     
  2. Click TOOLS -> WEB SETTINGS -> DATABASE
     
  3. Click ADD
    Leave the default name that appears in the Name Field as-is
     
  4. 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)
     
  5. Click BROWSE
    Select the appropriate yourdatabase.mdb file in your /fpdb folder and click OK
     
  6. 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
     
  7. Select your new database connection and CLICK VERIFY
     
  8. CLICK OK to finish and exit the 'Web Settings' menu
     

Send this page

     TOP | HOME  | CONTACT

                          © Copyright 2005 Acme Internet. All rights reserved.