Working with Microsoft Access
In order to read or write to Microsoft Access with AlphaDAO functions, you must have permission to read the database's System Catalog. To set permission to read the system catalog:
Open the database in Microsoft Access.
Make System Objects visible.
Select Tools > Options.
Check the check box for System Objects. The System Object tables will now be shown in the table view window.
Set permissions so that the system table "MSysObjects" can be read.
Select Tools > Security > User and Group Permissions.
Select "'MSysObjects'" in the Object Name list.
In the permissions box check Read Design and Read Data. You now will be able to read all the data from this MSysObjects table. This table contains the list of tables in the database.
Working with SQL Databases, SQL::Connection Methods and Properties
Alpha Five Version 8 Enterprise Edition
Desktop applications only.