How to Access Information from a CFR Database SECTION 13 CFR (Title 21 Part 11)
218
application folder - this is where the ‘Guest’ user is stored and has ‘Read’
access to the CFR database tables. It should then be possible to connect to
the database.
Example Connection String
Driver={Microsoft Access Driver (*.mdb)};
DBQ=C:\MyTestApps\Balloon\AuditTrail\BALLOON2_20101008_1.mdb;
SystemDB=C:\MyTestApps\Balloon\BALLOON2_Audit.mdw;
Uid=Guest;
13-7-2 Using Microsoft Excel
The following examples show how to access the CFR information using the
various versions of Excel.
Microsoft Excel 2003
• From within Excel, select the ‘Data | Import External Data | Import Data...’
menu option. This will invoke the standard ‘Open File’ dialog. Select the
appropriate CFR database file and click ‘Open’.
• The ‘Data Link Properties’ dialog will now be displayed with the selected
database file and user name ‘Admin’ shown in the ‘Connection’ tab.
Change the ‘User name’ to ‘Guest’ as shown below:
To Next Page
Loading...
Need help?
General