Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stop Permanent Conversion from 97 to 2000

Status
Not open for further replies.

EhWot

Technical User
Feb 25, 2002
14
US
Hey all, can somone help me out on this?;

Here's the deal:
The company I work for runs Access 97 at some sites and 2000 at others and I have a database that has to be availiable to all.

The db was developed in 97 and hence can be opened at all sites; if a 2000 user opens it, they get the option to permanantly or temporarily convert.

Trouble is, some 2000 users choose to permanantly convert and hence make the db unavailiable to the subsequent 97 users.

No problem, I thought, I'll just make the thing read only and hence they won't be able to permanantly convert, trouble is:

If you make the db Read-Only it won't let the 2000 users temporarily convert, and hence they can't read the thing!

Anybody got any ideas? Am I going about this all wrong? I don't really want to have separate 97 and 2000 front ends..

Any advice would be most gratefully recieved!

Thanks
 
A possible way forward would be to split the data so that all the data is in a seperate file. Then you could create seperate front ends for the 2 versions of Access. Access is not bothered what format the backend is, so your users will not be asked to convert it.

HTH

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top