Does anyone have any experience with the Win32::ODBC Perl module. If so, maybe you could help me with a problem.
I keep getting a runtime error when the script is run that says that the database could not be opened. That it is already opened or that I do not have permission to open it.
I know that it is not currently opened. Also, I have granted full permissions on the folder that houses the DB, the DB itself, the folder that contains the company intranet, the folder that houses the script, and the script itself.
The MS Access driver (the "Jet Engine") will always attempt to write a file named the same as your database but with an .ldb extension. This contains info on who is currently using the database, from what computer, etc. The Access driver also writes temporary files to perform it's work. If the account running the script does not have write (or add) permissions on the directory the script is running from, the Access driver will fail because it can not write these temporary files.