Defining Microsoft Access database files

You can define an ACL table from Microsoft Access database files saved in the file format of any version of Access between Microsoft Access 2000 and Microsoft Access 2010. You can also define ACL tables from earlier versions than Access 2000, but you must use ODBC to define the data file or save the data in another file format that ACL can define. You can define Microsoft Access data on your computer even if you do not have Microsoft Access installed.

To create a table from a Microsoft Access file:

  1. Select File > New > Table.
  2. If the Select Platform for Data Source page is displayed, select Local and click Next.
  3. Select Disk and click Next.
  4. In Select File to Define, locate and select the file you want to create the ACL table from and click Open. Microsoft Access database files have a .mdb or .accdb file extension.
  5. In the File Format page, verify that the Access database option has been selected and click Next.
  6. Complete the following steps in the Data Source page:
    1. Select the table or view to import. The available options are listed in the Select the Access Table/View list.
    2. If you want to increase or decrease the maximum number of characters imported from text fields, enter a new value in the Maximum Character Field Length text box. The value entered must be between 1 and 255.
    3. If you want to increase or decrease the maximum number of characters imported from memo or long text fields, enter a new value in the Maximum Memo Field Length text box. The value entered must be between 1 and 32768.
    4. Click Next.
  7. In the Save Data File As dialog box, modify the filename and location for the ACL data file, as necessary, and click Save.
  8. In the Final page, verify the settings for the new ACL table and click Finish.
  9. Enter a name for the ACL table you are adding to your project and click OK.


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback