Re^2: MS Access database problem

[vdubjunkie]

I am ASTOUNDED

to learn that EVERY page I found led me to believe you could simply access it by the filename. Believe it or not, I searched high and low prior to posting here, and I never saw a page even reference HOW to open a MS Access database by it's DSN rather than it's name...

Needless to say..

That worked!!

A huge thank you

..oh, and no, the space before (*.mdb) didn't matter as doesn't capitalization on DBI, etc.. for those searching these forums later.

[tachyon-II]

Actually having just read the pod for DBD::ODBC they have introduced direct access to mdb files since last I looked (6 years ago more or less :-). I think your original code would have worked if you had specified the full path to the testdb.mdb file. See DBD-ODBC/ODBC.pm#Connect_without_DSN

Anyway glad you got it working. As noted in the DBD::ODBC pod if you use the DSN method that worked for you then you need to make it a system DSN, not a user DSN.