Maybe, I should have been a little more clear on what was happening.



The Access 2000 databases work fine on PWS, which I run locally before 

sending my pages up to the Internet.



The problem lies on accessing the Access 2000 db on the intenet.  The error 

that I get is:



Database Results Error

[Microsoft][ODBC Microsoft Access 97 Driver] Can't open database 

'(unknown)'. It may not be a database that your application recognizes, or 

the file may be corrupt.



What I'm lead to believe is that the web server is not running the latest 

Access Driver to enable me to view the db results.



At least I know that when I send an Access 97 db up everything works fine, 

thank goodness that Microsoft decided to incorporate the backwards 

compatability for saving databases.



Rod Aubertin

I had this problem.



I found that some machines are very picky on the version of MDAC, and ADO...



I was using version 2.1 on the local machine, installed version 2.5.

and also had differnet JET versions, 3.51 or 4.0



Make sure you have everything referenced to the correct version.



Phil.

> The problem lies on accessing the Access 2000 db on the intenet.  The

error

> that I get is:

>

> Database Results Error

> [Microsoft][ODBC Microsoft Access 97 Driver] Can't open database

> '(unknown)'. It may not be a database that your application recognizes, or

> the file may be corrupt.

>

> What I'm lead to believe is that the web server is not running the latest

> Access Driver to enable me to view the db results.



That would be the correct conclusion to draw. Get your ISP to update the

MDAC that they are using...



Everyone should be using at least MDAC v2.1 SP 2 (due to vulnerabilities in

previous versions), and v2.1 SP2 supports Access 2000 databases.



Cheers

Ken