Important A data access page is connected to either a Microsoft Access or Microsoft SQL Server database. For the page to work properly, the database must be available to users of the page.
To publish a data access page file by saving it to Web Folders
-
When you first create the page, save it to a Web folder underneath Web Folders. If you create the page in a location other than a Web folder underneath Web Folders, you can move the corresponding HTML file and related files and folders by using the Save As command on the File menu in Access.
Notes
-
Access automatically saves related files such as graphics, style sheets, linked files, and the folders that contain these files when you save any Web page to Web Folders.
-
You can only use the Web Folders shortcut or enter a Uniform Resource Locator (URL) in the File name box of the Open dialog box when you edit a Web page that already exists or create a data access page in page Design view.
To publish a data access page to a Web server
-
Copy the HTML file corresponding to the page and any other related files and folders in Windows Explorer to a folder underneath the root directory of the Web server. The default root directory is \Webshare\Wwwroot for Personal Web Server and \Inetpub\Wwwroot for Microsoft Internet Information Server.
Publish server-generated HTML files to a Web server
To use server-generated HTML files (either ASP or IDC/HTX) on a Web server, you need to do the following.
- Install the appropriate software on the computer that will be the Web server and that will process the server-generated HTML files.
- Create a folder under the root directory to contain the ASP or IDC/HTX files. The default root directory is \Webshare\Wwwroot for Personal Web Server and \Inetpub\Wwwroot for Microsoft Internet Information Server.
- Copy the ASP or IDC/HTX files to the folder. Copy related files such as graphics, linked files, and any folders that may contain these files to the folder, or make sure the related files can be located by the Web server software.
- Either copy the Microsoft Access database or SQL Server database to the folder, or define its network location in the ODBC data source definition in step 6.
- Define the ODBC data source as a System DSN on the Web server. Make sure that the data source name is the same name as the one you entered in the appropriate Output Options dialog box when you output the ASP or IDC/HTX files.
- If desired, define database security for the ODBC data source, but ensure that users can access the ODBC data source, by doing one of the following:
-
For a Microsoft Access database (.mdb), create a user-level security username and password to allow users to access the Access database from the Web page. If you do not create a user-level security username or password, the default username is Admin, and no password is used.
Warning This will allow anyone with default Administrator privileges to access your database from the Web page. It is highly recommended that Administrator accounts have strong passwords assigned to them. Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh%et5 Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.
-
For a Microsoft Access project (.adp), in the Username and Password boxes, create a database username and password to allow users to access the Microsoft SQL Server database from the Web page. If you do not create a username or password, the default username is Sa, and no password is used.
Warning This will allow anyone with default Administrator privileges to access your database from the Web page. It is highly recommended that Administrator accounts have strong passwords assigned to them. Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh%et5 Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.
The username and password must match the username and password that you enter in the User to Connect As and Password for User boxes of the Microsoft Active Server Pages Output Options or HTX/IDC Output Options dialog boxes that appear when you output the ASP or IDC/HTX files.
-
Note If you need to export multiple datasheets, you can automate the operation by creating a macro or creating a Visual Basic for Applications program. This is particularly useful when you frequently export datasheets to test and build a Web site.
Publish static HTML files to Web Folders or any Web server
- Do one of the following:
- To publish a static HTML file to Web Folders, copy the static HTML file(s) to a Web folder under Web Folders by using Windows Explorer.
- To publish a static HTML file to a Web server, copy the static HTML file to a folder under the root directory of the Web server by using Windows Explorer. The default root directory is \Webshare\Wwwroot for Personal Web Server and \Inetpub\Wwwroot for Microsoft Internet Information Server.
- Copy related files such as graphics, style sheets, linked files, and any folders that may contain these files to the folder, or make sure the related files can be located by the Web server.
Note If you need to export multiple tables, queries, forms, and reports, you can automate the operation by creating a macro or creating a Visual Basic for Applications program. This is particularly useful when you frequently export tables, queries, forms, and reports to test and build a Web site.