ODBC connection with Access and Perl

L

Linda

I have a perl script which I would like to call from my Access database
switchboard. The script searches files in a directory and compares them to
entries in a database table to see if they have been imported. If not, it
parses the file and imports the data to another database table. The script
itself works. However, once I call it from within the database I get an
error that says the "DBI connect failed. The database has been place in a
state by an unknown user that prevents it from being opened or locked." The
database default open mode is shared. I have not specified "exclusive" on
the ODBC connect command. Does anyone know how I can get around this problem?
Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Table Security in Access 2013 1
Creating a Search using a combo box and then creating a report. 4
Update Access table from Perl script via ODBC 4
Running PERL script from Access VBA 1
Total parameter query and ODBC-call failed 0
split data base using ODBC connection 1

Top