DSN-Less connection works with Access2000, but not Access97

[Rexolio]

I am using a dsn-less connection to connect to an Access database. I created this for a friend. When I upload an Access 2000 file and test the script it works, but when he uploads an Access 97 file (same format/layout obviously) it doesn't work and says the file may be corrupt. If I take his 97 file and convert it to 2000, it works!!! I used 97 files a couple of years ago without problems. Is there something I'm missing? Here's the dsn-less connection I'm using:

PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:\inetpub\

http://wwwroot\sites\database.mdb

 

[vasah20]

That's because Access97 and 2000 have different DSN-less strings. They use a different provider each. Keep in mind that you should test all your queries out in 97 first. If you have simple insert, update, delete or select queries, you should be fine... but if you are aliasing your tables, use transitive tables or multiple joins or anything else more complex, you might want to give it a runthrough in the query analyzer.

2000:
PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:\inetpub\

http://wwwroot\sites\database.mdb

97:
PROVIDER=MICROSOFT.JET.OLEDB.3.51;DATA SOURCE=d:\inetpub\

http://wwwroot\sites\database.mdb

hth
leo

 

[Rexolio]

Thanks so much. However, I tried 3.51 and still the same error. Don't suppose you have any other suggestions?

 

[vasah20]

instead of using the OLEDB layer, have you tried going through ODBC?

Driver={Microsoft Access Driver(*.mdb)};DBQ=d:\inetpub\

http://wwwroot\sites\database.mdb

You might want to double check that...

anyways - if you can't connect through ODBC, then there might be something wrong with the 97 DB...

hth
leo