I sent this message to tech support, but I figured that I would likely get 
a faster reply from this forum.  

I am in the process of filling out the testsailor.asp script.  I got 
everything to work up until the last test which is to print the first 
record of SAILORS.MDB (Adam).  I am adding lines one at a time to see when 
it breaks; and it does break with the following line:

  oRS.open "Select * from People", "DSN=sailors"

With that line included, I get the following errors:

************************
Error Type:
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.  
/iishelp/aspdatabases/testsailor.asp, line 21

Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) 
************************

I do have a system DSN named "sailors" that points to the 2000 version of 
the database I downloaded from WROX.  Since I own a copy of Access 2000, I 
decided to convert Wrox's lower-version of the database so that I may view 
its contents in 2000.  Since I am running this on my personal computer, I 
have absolute certainty that no one is on the database when I run the 
script, and I've checked to see that all the tables have full permissions.

Then I ran these tests: I eliminated the DSN entirely and reran the 
script; and I got a different error.  Then I recreated the DSN and pointed 
to the database provided on the download and got "Unspecified error."  
Then I pointed to my 2000 version; and my original error, as shown above, 
reappeared.

Any thoughts?

Peter Ferber
peterfrb2@y...

the error has TWO origins.  the first, the databse is open (usually opened 
in design view or something), which you said you are certain is not the 
case.  but did you set up any password type authentication for the 
database?  that is the only other reason i can see you getting it.  if 
that is the case, pass the username and password to the database.

also, try assigning the full DSN to a variable and passing the variable to 
the oRS.Open method instead of the hardcoded string.  if this doesnt work, 
you can send me a copy of the DB and ill try to recreate the error.

ron

> I sent this message to tech support, but I figured that I would likely 
get 
a>  faster reply from this forum.  

> I am in the process of filling out the testsailor.asp script.  I got 
e> verything to work up until the last test which is to print the first 
r> ecord of SAILORS.MDB (Adam).  I am adding lines one at a time to see 
when 
i> t breaks; and it does break with the following line:

>   oRS.open "Select * from People", "DSN=sailors"

> With that line included, I get the following errors:

> ************************
E> rror Type:
M> icrosoft OLE DB Provider for ODBC Drivers (0x80004005)
[> Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database 
e> ngine cannot open the file '(unknown)'. It is already opened 
exclusively 
b> y another user, or you need permission to view its data.  
/> iishelp/aspdatabases/testsailor.asp, line 21

> Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0) 
*> ***********************

> I do have a system DSN named "sailors" that points to the 2000 version 
of 
t> he database I downloaded from WROX.  Since I own a copy of Access 2000, 
I 
d> ecided to convert Wrox's lower-version of the database so that I may 
view 
i> ts contents in 2000.  Since I am running this on my personal computer, 
I 
h> ave absolute certainty that no one is on the database when I run the 
s> cript, and I've checked to see that all the tables have full 
permissions.

> Then I ran these tests: I eliminated the DSN entirely and reran the 
s> cript; and I got a different error.  Then I recreated the DSN and 
pointed 
t> o the database provided on the download and got "Unspecified error."  
T> hen I pointed to my 2000 version; and my original error, as shown 
above, 
r> eappeared.

> Any thoughts?

> Peter Ferber
p> eterfrb2@y...