Show All
Import a database
About importing a database into your web site
- A database imported into a server-based web site can
be used without the involvement of a server
administrator or Internet service provider
(ISP). A System DSN, on the other
hand, requires access to the resources and file
system of the web server.
- If you have a disk-based web site that you want to
publish to a server-based web site, the database
on the disk-based web site, and the database
connection, will transfer to the server-based
web site during publishing. You won't need to
create a new database connection on the
destination web site or involve a server
administrator or your ISP.
- If the database you're importing is a Microsoft
Access database, you will be asked to create a
database connection and to store the file in the
Fpdb folder. Permissions are set for the
Fpdb folder specifying that the folder can't be
viewed in a Web browser. You can protect the
privacy of your database by moving it into the
Fpdb folder.
- Also with an Access database, you can enter data
into the database through a web interface. The
data will then be available to other Microsoft
Office applications that can connect to Access
databases.
How to import a database, create a
connection, and display data
- On the File menu, click Import, click Add
File, and then select the database you want
to import.
- To create a new database connection, type a name for
the connection in the Name box.
-
To display information from the database on a
page, start the Database Results Wizard by
clicking the Insert menu, pointing to Database,
and then clicking Results). Follow the
steps in the wizard.
Note Depending on its
size, it might take several minutes to import
your database.
Before you view the database results
To view the data once you set up the connection and complete
the steps in he Database Results Wizard, your web site must
be hosted or published on a web server configured with:
Ask your Internet service provider (ISP) or web server
administrator whether your web server is configured with these
options.