Bill,
I had a similiar problem, and it was a rights problem. What you'll need to
check are the NTFS permissions on the directory and the MS Access database
file. Specifically, the IUSR_SERVERNAME and, depending on how the IIS
server is configured, the IWAM_SERVERNAME accounts need to be able to add
files to the directory. This is because an .ldb file is created when the
Access file is opened. The .ldb file is basically a locking file so that
Access knows who has what opened. If it can't create an .ldb file, then it
'thinks' the file is opened exclusively by another user.
The IUSR_SERVERNAME (IWAM_SERVERNAME) accounts are used by IIS to access
the filesystem. This is assuming that you have Anonymous Access configured
for IIS.
Of course I'm assuming that you are running IIS.
HTH
Joe Moore
On 05/07/00, ""Mark G. Franz" <[EMAIL PROTECTED]>" wrote:
> The drivers are either loaded with Access or by loading the MDAC 2.1/2.5
> drivers. The error you are encountering is caused by the DSN reading the
> handle and seeing that it is already open by another session connection.
> You MUST close any session handles you open in your code.
>
> Or you don't have the MDAC drivers loaded on your server. Load the drivers,
> repair your DSN connection and all ~should~ be fine.
>
> But still, you should always close any open handles...
>
> Mark
>
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]