Microsoft Access & Perl

Stky10

Anyone got any tips/advice/web page links to programming writing to Microsoft Access database
files using Perl???. Is it even possible??.

I

Stky10

Whoops wrong place.....

How did it end up in here???

I'm at a loss....ah well...

If theres an administrator/moderator reading this they can delete it...

damnyanks

I remember www.sitepoint.com having a good enough tutorial on Perl with MySql.

If you are trying to use access I'm guessing your on a windows machine in which case ASP may be a better alternitive. (Or at least easier )

netman

It's possible.

You will need to install the DBI module for Perl, and then install the correct drivers - a DBD module.

For Microsoft Access, you will need the ODBC module.

Here's a good tutorial on how DBI works:
http://www.perl.com/pub/a/1999/10/DBI.html

As to the ASP comment, there are a few reasons why you might want to stick with Perl:

1) ASP is a web technology, if you're writing a stand-alone application then ASP won't do. (VB will do, but it's a slightly different thing)
2) ASP is platform dependent, it only runs on Windows. Since you're using Microsoft Access then it probably won't matter to you, but the Perl code you write can be just copied over to a Unix, Linux etc server and it will run just fine.

Having said all that, I believe Perl will be slower than ASP if you're writing a web application, so if that's the case with you, why not give ASP a shot instead?

damnyanks

Or PHP or any number of scripting languages out there

Access is also platform dependent.