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]

Reply via email to