Help! Compatibility between Access versions

[beatleman]

Hi all, I have created a database for work in Access2003. I have two questions. The first is, many people at the work place use AC97 and some use AC2000. In order for everyone to use the database, i have saved it in AC97 format. It seems to open fine in Ver2000 and 2003, but i get this nag screen on load up with these versions saying "do you wish to convert the database". As I'm working off a shared drive, i don't really want anyone converting the dbase. Is there a way to disable this nag screen when loading in AC2000 and AC2003??

Second question, is it possible to have more than one instance of the database open at anytime? . If I've got the database open, my colleague can't open it. Its a simple database that writes records directly to a table. Thanks for any advice.

 

[Len Boorman]

Have this situation all the time
Solution is

1) Data Repository in Access 97
2) Separate Interfaces Access 97, 2000 and 2003 with linked tables back to data repository
3) Tell the buggers to use the interface compatible with their version of Access

Works a treat

If you have modifications do them in the 97 interface

In other interfaces delete all queries forms reports macros,modules

Import complete new set from 97 interface

L

 

[Pauldohert]

Maybe runtime FE would solve this.

 

[boblarson]

Maybe runtime FE would solve this.

To do that you would need to be able to use the Access runtime, which is only included with the developer editions - except Access 2007, but the 2007 one isn't available yet - we keep hoping anytime soon, but still not there.

So, unless they have a copy of Microsoft Office Developer Edition, then they are kind of out of luck for the runtime until the 2007 runtime comes out.

 

[The_Doc_Man]

Answer to second question: Sounds like the database has not been properly secured. The "one user at a time" symptom is OFTEN (but not always) caused by failure to properly set up the workgroup file. Search this forum for lots of articles on this topic.