Access 97 and 2000 - can I input data?

[aranj]

My query concerns editing an Access 97 database in Access 2000.

I do not want to convert the 97 database as it is the underlying data behind a commercial application.

When I open the 97 db in Access 2000 it reports "you can't make changes to the database objects".

All I want to do is to quickly enter lots of repetitive data in a field in a table - I do not want to change any actual field types or tables etc.

I want to do it this way as the data I want to input takes a very long time due to the way that the front end is designed.

Is it safe for me to do it this way?

Thanks in advance.

 

[jeremie_ingram]

What about creating the tables in the version you have and save it as a previous version format. Then you can enter the data, and have it imported to the existing system, if this is an option.

 

[rpadams]

Split your database

Why not split the tables and leave them in Ac97 format. You can then make either a Ac97 or Ac2K front end and link to the tables in the backend. Ac2K reads the old tables with no trouble and you can still make changes to the front end if you need to. Caution: Some features of Ac2K that relate to the way the tables are viewed (eg. subdatasheets) won't be present in the Ac97 frontend.

 

[aranj]

Thanks to both of you.