Creating Data Sources and Databases
After you've installed an ODBC driver for Access, you'll need to create databases and corresponding data sources for them. A data source simply stores the information needed to connect to your database. The easiest way to create an Access database and a corresponding data source from scratch is to create them both at the same time with the ODBC Data Source Administrator:-
Choose the ODBC option in the Control Panel.
An ODBC Data Source Administrator panel opens.
-
Click the System DSN tab.
System data sources are accessible to all users, including NT services. It's important to create system data sources instead of user data sources, especially for use with WebObjects, because autolaunched applications aren't able to access user data sources.
-
Click Add.
The Create New Data Source panel opens.
- Select the Microsoft Access Driver.
-
Click Finish.
The ODBC Microsoft Access Setup panel opens.
-
Type a name for your data source in the Data Source Name field (Movies, for example).
Remember the name you provide because later you'll it to login to your database.
-
In the Database section of the panel, click Create.
A New Database panel opens. You'll use this panel to create a new, empty database.
- Type a name for your database in the Database Name field (Movies.mdb, for example).
- Choose a directory where you want the database located.
-
Click OK.
A panel opens telling you that the database was successfully created.
-
In the ODBC Microsoft Access Setup panel, click OK.
© 1999 Apple Computer, Inc. (Last Updated 19 Oct 99)