• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS Access 97 / 2000

 
Stanley Tan
Ranch Hand
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 276
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yup, I'm using the right driver. Even when I double-click the file, it doesn't want to open.
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 243
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic