Engineering Microsoft Access Databases |
You can engineer your Access databases through ODBC. However, some object properties are not available in this way. Also, not all DDL scripting commands are recognized by Microsoft Access.
Because of this, we've provided an extra feature for engineering Access databases "directly". Instead of setting up an ODBC data source, you simply specify the path to your mdb file. In order to use this functionality, you must have Access installed on your machine.
there are a couple of additional steps you should take before starting the engineering process to allow Visual Case to get information about referential integrity.
Open your Access database in Microsoft Access.
Select Options from the Tools menu.
Make certain that "System Objects" is checked and click OK to close the Options window..
Select Security > User and Group Permissions from the Tools menu.
On the Permissions tab, select MSysRelationships and make certain "Read Data" is checked.
Related Topics: