Hi- I'm working through 'Beginning ASP Databases', and trying the first 
example, which opens a connection to an access database.  I converted the 
sample database to Access2000.  The os is XP Professional with IIS 5.1, 
using NTSF file system.  I get the popular error

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[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.
/testsailor.asp, line 20

The database is on my c drive, with a DSN connection to the db.  I right 
clicked the folder containing the asp file and the db, and I see 'read-
only' is checked off.  So I uncheck it, and click OK.  I look at the 
properties again, and read-only is checked off again.

Any ideas?

error was:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[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.
/testsailor.asp, line 20



Made sure you don't have your database open for editing in Microsoft Access?

No, I checked.  Actually, I just tried creating a new
folder, sharing it out, script execution rights, and
it seemed to work.

I checked all that on my wwwroot directory, but there
it didn't work.  But it does on the new.  Don't
know....
--- Daniel Watts <danielwatts@c...> wrote:
> error was:
> 
> Microsoft OLE DB Provider for ODBC Drivers
> (0x80004005)
> [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.
> /testsailor.asp, line 20
> 
> 
> 
> Made sure you don't have your database open for
> editing in Microsoft Access?
> 
> 

well try a search for "databasefilename.ldb" and see if a lock file exists.
i think that should always be in the same directory as the MDB actually.

If there is one then something is locking the database and not releasing it.
I'm not sure if this might be caused by opening a connection via asp that
isn't closed at the end by the db.close ; set db = nothing statements...



-----Original Message-----
From: bounce-access_asp-1177363@p...
[mailto:bounce-access_asp-1177363@p...]On Behalf Of Dennis
Stevens
Sent: Sunday 01 September 2002 01:21
To: Access ASP
Subject: [access_asp] RE: Access permission problems



No, I checked.  Actually, I just tried creating a new
folder, sharing it out, script execution rights, and
it seemed to work.

I checked all that on my wwwroot directory, but there
it didn't work.  But it does on the new.  Don't
know....
--- Daniel Watts <danielwatts@c...> wrote:
> error was:
>
> Microsoft OLE DB Provider for ODBC Drivers
> (0x80004005)
> [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.
> /testsailor.asp, line 20
>
>
>
> Made sure you don't have your database open for
> editing in Microsoft Access?
>
>