Compatibility with 2000 (Access 97)

Topic

New Reply

I need to share Access files with someone who uses Access 2000. She said that she can not open my Access 97 file without first making a copy of it and using that copy to work with. She spoke to someone at Microsoft who gave her this info. Does this make sense???
Thanks for your help with this puzzling question.

Reply | Quote

Replies

If someone with Access 2000 opens an Access 97 database, she is presented with two options:
1. If she needs to be able to modify the design of forms etc., she must convert the database to Access 2000 format. The Access 2000 database must be saved under a different name. Perhaps this was meant by making a copy – the original Access 97 database is left untouched.
2. If she only needs to use the database, she can open the database in Access 97 format; in that case, she won’t be able to modify the design of forms etc., but she can enter and edit data, view reports etc.

Reply | Quote

Thank you, Hans. You explained the situation quite clearly and so quickly!. Now I understand.
Libbie

Reply | Quote

Hans
Do you know if there is any difference in efficency between converting or not converting a A97 frontend to A2000 when working with a A97 backend?

Peter

Reply | Quote

I don’t know, I have never measured performance differences.

Reply | Quote

Access 2000 front ends are slow when linked to 97 backends, if that answers your question. If you’re talking about simply opening the 97 front end in 2000 rather than converting it, it will still be slow.

Reply | Quote

I had thought that the company standard was for A97 but it turns out that a few managers have A2k. I have produced a Database that will be used factory wide but only 2 people will have write privileges in the DB, using user-level security.

I have not had a chance to test the DB using A2k but if there is no real speed advantage in conversion then I will try to just open the DB in A2k which will save me problems when I have to change the design yet again!

Peter

Reply | Quote

You want to be sure to split it if you haven’t already – otherwise one of your managers will convert it and then only the folks with 2000 will be able to open it!

Reply | Quote

The company I work for recently upgraded from 97 to 2000, until all the users were upgraded the systems were left as 97, once the site wide upgrade was completed I converted the databases to 2k.

The only problems I had reported was a drop off in performance while using the 97 system in 2k, once the conversion was complete the systems appeared to run more quickly and definitely take up less server space than they did before.

I did quickly set up the basic Microsoft security, to stop users from converting the systems accidentally, but this was not time consuming.

Hope this is useful.

Ian

Reply | Quote

I have the DB split and secured, the managers get the form it opens on and that

Reply | Quote