Sharing Database with 2000 and 97

[knowidea]

I have followed the instructions on sharing a Database across severel access versions, from the book &quot;Access 2000: The Complete Reference&quot;, but I am still unable to open the database in access 97.<br>Did I miss something before or after converting, spliting, and linking.

 

[DougP]

Once you convert a database it cannot be opened in an earlier version. This is true of a lot of software. Like Word or Excel<br>The new features of th enewer version were not around back when they wrote the original. That's why when you open the old .mdb for the first time it asks if you want to Convert it or Just open it.<br>If you need to view the data from either you can &quot;Link&quot; just the tables from either 2000 or 97 to either one.<br>Click the Tables TAB and Right click in the White space<br>then Click &quot;LInk&quot;. Then follow the prompts.<br><br><br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[knowidea]

thank you for your reponse. Then y is does it say that it can be done in the book that i just spent money on!!&nbsp;&nbsp;Just venting, cause I spent $40 on this book.<br>thanks again for your help.

 

[JimConrad]

Please be more specific in what you are trying to accomplish.&nbsp;&nbsp;You have an application written in Access 2000 that you want someone else to be able to use and that other person has Access 97? <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[elizabeth]

This can be done two ways that I know of. You can leave the db in Access 97 and then open it with 2000 or 97. However, you must make sure that no one &quot;accidentally&quot; converts it to 2000 when they open it, as this is an open <i>option</i> that Access offers the <i>first</i> time you (or each user) opens a 97 version with 2000. I've done this with multiple dbs and it's worked fine<br><br>The other way is if you built it in 2000 you should be able to convert it <i>back</i> to 97 and then use as above. I have not done this so can't say how it works.<br><br>Either way, when you open 97 with 2000, Access seems to make a second &quot;2000&quot; version copy that it uses in the future, so the db is bloated and this may affect performance.