Search these areas:
Help
Support Forums
Product Info



Introduction
DataWeb: What's New
Creating an Application
The DataWeb Designer
Application Management
Data Tables
Data Tables
Views
Templates
Components
Data Analysis
Members
Security
Importing
-Importing an Access Database
Importing 20+ MB Databases
Tips for Successful Access Imports
-Importing an Excel Worksheet
-Importing a Text File
-Importing a Web Site
-Importing a Web Archive
Exporting
FTP
JavaScript
Object Model
Full-Text Search
Domain and Email Hosting
HotBlock Modules
Account Management
Glossary
New Responsive UI Module





DataWeb Help
Support Forums
Tutorial
Script Library
Knowledge Base

Home > Support

DataWeb User's Guide

Importing an Access Database
You can import the tables from an existing Access database into a DataWeb web. Each table in your Access database will become a data table in your Web application.

When the DataWeb platform imports your Access database, it does the following:
  • Imports all of your tables and data into DataWeb data tables
  • Maintains each table's primary key
  • Maintains field data types
  • Imports your relationships and automatically creates lookup fields
  • Imports your table and field captions and descriptions
The import wizard will preserve as many of your data types, primary keys, and lookups as possible. Before attempting to import an Access database, see Tips for Successful Access Imports to ensure that your database imports exactly the way you intend it to.

For security reasons, DataWeb limits the size of an uploaded file to 20 MB. If your database is larger than 20 MB, see Importing 20+ MB Databases.

To import an Access database:
  1. In the DataWeb Application Designer, click the folder in the File Directory into which you want to import the Access database.
  2. From the File menu (at the top of the designer), mouse-over the Import option and select Import data from access DB.
  3. In the next window; you will be presented with the option to click a button Choose File where you can select an Access DB from your local computer.
  4. Or select the Import file from DataWeb application and type in the url of the Access DB (ex. http://yourweb.dataweb.com/access.db).
  5. In the appropriate text box, enter the path to the .mdb or .zip file that you want to upload.
  6. If your Access database is password-protected, enter it in the Database Password text box.
  7. If you want existing data tables in your Web application to be overwritten by imported tables with the same name, select the Overwrite existing tables option.
  8. Click the Import button to start the import process.
    It may take several minutes to upload your file. Once the upload is complete, you will see a progress indicator showing the import status of each table in your database.
  9. When the import status displays Process Complete, click OK.
Your database import is now complete.
Affiliate | Partner | Terms of Use | Privacy Policy | Contact Us | Pricing | Bring DataWeb In-House    
DataWeb, 720 North 10th Street, A #145, Renton, Washington 98057 *425-583-5970* Fax 484-770-4706* Email Us