Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

MS Access

Posted Sep 13, 1999

Dabbling in Live Databases: MSAccess - Page 3

By Aaron Weiss

Preparing Microsoft Access

Our focus on MS Access this month is not an endorsement, per se, but because it is an easy-to-learn and popular database application. Of course, we're not going to spend time on the ins and outs of using the Access interface ... suffice it to say, this article will have to assume that you have or can figure out how to create a database within Access. To help follow along, you might consider re-creating the sample database we featured earlier in this article, named clients, with two tables, billing and invoices.

Now, let's cut to the chase: you have a database ready-to-go in Microsoft Access and you're chomping at the bit to start coding a Perl-based query script. First, you'll have to register your Access database with Windows' ODBC, or Open Database Connectivity, control. This will allow our Perl modules to "speak" with the Access database, as they share a common communication protocol. You can find the ODBC control in the Windows Control Panel. Launch the ODBC Data Sources control panel and select the System DSN tab.

You can see that we've already added our clients database to ODBC; you can do this by clicking "Add", selecting the "Microsoft Access Driver (*.mdb)", and then Finish. The next window lets you select a Data Source Name, or DSN, which is the name of this database as you'll refer to it from your Perl script. We chose Clients (Windows systems are generally case insensitive, although Perl itself is case sensitive), as well as the actual database file you wish to register. Voila! -- Perl will now be able to talk to your Access database courtesy of the ODBC protocol.

Now that your Access database has been created and registered with Windows' ODBC control panel, we can turn our attention away from Access-specific information and look to Perl and all the wonders within....

MS Access Archives

Latest Forum Threads
MS Access Forum
Topic By Replies Updated
Help With Microsoft Access kasy 0 September 4th, 07:35 PM
Linked table not sorting or filtering - ODBC error Java 1 August 28th, 10:37 AM
Use Parameter in select statement (Sql in Microsoft Access) katty.jonh 1 July 25th, 06:45 AM
Query Issue algebroni 7 July 23rd, 04:22 PM