aspose file tools*
The moose likes JDBC and the fly likes MS Access 97 / 2000 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS Access 97 / 2000" Watch "MS Access 97 / 2000" New topic
Author

MS Access 97 / 2000

Stanley Tan
Ranch Hand

Joined: May 17, 2001
Posts: 243
I created a database in Access 2000 and now I am on a computer with Access 97. I can't open the file and I can't run the Java application that uses the file. The error message is:
It may not be a database that your application recognizes, or the file may be corrupt.
I don't believe the file is corrupt because I was working with it in the morning and I can the same errors with the backup database. Is there an incompatability between Access 2000 and 97? What should I do?
Daniel Dunleavy
Ranch Hand

Joined: Mar 13, 2001
Posts: 276
if you are using odbc, I would check that you choose the odbc driver for access 97 when creating the datasource on the access 97 machine.
Dan
Stanley Tan
Ranch Hand

Joined: May 17, 2001
Posts: 243
Yup, I'm using the right driver. Even when I double-click the file, it doesn't want to open.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

If you created a database in access 2000, you will not be able to open it using access 97. It isn't backward compatable in most cases. If you are trying to access the database using java from a machine that only has access 97, how did you set up the ODBC datasource using the access 2000 drivers? I believe it has a different set of drivers than MSAccess97 that won't be installed on your machine if you don't have Access2000 on it.
From experience I can tell you I wasn't able to open a MSAccess2000 database in MSAccess97. I also know that when programming using ado, the drivers for the 2 databases are different. So I can only assume that the same is true for java.

Jamie
Stanley Tan
Ranch Hand

Joined: May 17, 2001
Posts: 243
Thanks. I just rebuilt the database in Access 97. Does 2000 have a SAVE AS option to save as Access 97 format?
fengzixuan zheng
Ranch Hand

Joined: Aug 02, 2001
Posts: 31
Dear Stanley,
I have a question, how you creat the connection the the MS Access 2000 table? Would you like to do me a favour to mail me a copy of the source codes.
Thank u,
Anyone who can help please mail to me: fengzixuan@21cn.com
sabbir kazi
Ranch Hand

Joined: Feb 03, 2001
Posts: 62
I am facing somewhat similar problem. I have created my database in Access2K, running fine on Win2K, but trying to port my application on winNT 4 (SP6) which don't have a JDBC-ODBC driver for Access2K, so getting a "JDBC Connection Failure" message when try to run my program.
How can I install the correct driver on winNT 4 (SP 6)? Just installing the Access2K will do??
Please answer.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Originally posted by sabbir kazi:
I am facing somewhat similar problem. I have created my database in Access2K, running fine on Win2K, but trying to port my application on winNT 4 (SP6) which don't have a JDBC-ODBC driver for Access2K, so getting a "JDBC Connection Failure" message when try to run my program.
How can I install the correct driver on winNT 4 (SP 6)? Just installing the Access2K will do??
Please answer.

Why can't you use the jdbc-odbc bridge? Install access 2000 on your NT machine, create the database, then set up the odbc data source. Once you install access 2000 on your NT machine, the new drivers should be installed and accessible as an odbc data source.
Jamie
 
jQuery in Action, 2nd edition
 
subject: MS Access 97 / 2000