Steve When an Access .mdb file is opened (even for reading), the Jet engine creates a .ldb file in the same directory for locking purposes. So if your page is not password protected, then the anonymous user (IUSR_machinename by default) needs write access to the database directory. If your page is password protected, then the username(s) you authenticate with need write access. Regards Grant ===================================================================== Grant McLean | email: [EMAIL PROTECTED] | Lvl 8, 86 Lambton Quay The Web Limited | WWW: www.web.co.nz | PO Box 15-175 Internet Solutions | Tel: (04) 495 8250 | Wellington Awesome service | Fax: (04) 495 8259 | New Zealand > -----Original Message----- > From: Kirkup, Steve [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 27, 2000 8:42 PM > To: ActivePerl (E-mail) > Subject: Access w/IIS > > > Hi, > > I am trying to get a Win32::ODBC script to work with IIS. > I actually got > to work on another machine, > and so I know the script works on IIS. I can even run the > script from the > command line and it works fine. > When I try and run it on from the Web Server I just get this > error message. > > [-1032] [] "[Microsoft][ODBC Microsoft Access Driver] The > Microsoft Jet > database engine cannot open the file '(unknown)'. It is already opened > exclusively by another user, or you need permission to view its data." > > I checked everything and I have basically run out of ideas. The only > difference that I can find is that > the versions of ODBC are different, 4.00.42 vs a 4.00.44, > anyone got any > ideas? > > Steve K > > _______________________________________________ > ActivePerl mailing list > [EMAIL PROTECTED] > http://listserv.ActiveState.com/mailman/listinfo/activeperl > _______________________________________________ ActivePerl mailing list [EMAIL PROTECTED] http://listserv.ActiveState.com/mailman/listinfo/activeperl
