using Access 2003 and 97 for same database

[Guest]

We have a database made in Access 97. Three people use this database. The
two who do any kind of data entry or database modifications have Access 97.
The third person, who just does data lookup, has 2003. The 2003 user always
gets a "Do you want to convert..." request when opening the DB. Would
splitting it into FE/BE solve this problem? In other words, would the FE
just recognize the BE as Access data and not pay any attention to the version
on which the data was designed and saved? We're just afraid that sometime
she might hit "yes" instead of "no" to the request to convert, then we'd have
a problem! We are a non-profit and can't afford to just update our software
at the drop of a hat! Thanks!

 

[Douglas J Steele]

Yes.

The back-end obviously needs to remain in Access 97 format. You should have
two copies of the front-end: one in Access 97 format, and the other in
Access 2003 format. Each user should have his/her own copy of the
appropriate front-end, preferably on their hard drive. If you need to make
changes, you should make them in the Access 97 version, and convert to
Access 2003 when done, rather than vice versa.

 

[Guest]

Hi Susan,

Would splitting it into FE/BE solve this problem?

Yes. As long as each user has a copy of the FE file. The best thing to do is
install a copy of the FE on their local hard drive.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

We have a database made in Access 97. Three people use this database. The
two who do any kind of data entry or database modifications have Access 97.
The third person, who just does data lookup, has 2003. The 2003 user always
gets a "Do you want to convert..." request when opening the DB. Would
splitting it into FE/BE solve this problem? In other words, would the FE
just recognize the BE as Access data and not pay any attention to the version
on which the data was designed and saved? We're just afraid that sometime
she might hit "yes" instead of "no" to the request to convert, then we'd have
a problem! We are a non-profit and can't afford to just update our software
at the drop of a hat! Thanks!

 

[Guest]

Thanks, fellows. You came through, as usual!!!