upgrading existing databases

[AlexUK]

what is the easiest way to upgrade an existing database<br><br>i have altered and upgraded a database which is already in use by a client. the upgraded version two is on my machine. what is the easiest way to import the new relationships, forms and tables etc to the original?<br><br>thanks to everyone who has helped so far, much appreciated.<br><br>AlexUK

 

[DougP]

Do you mean like upgrade from Version 2 to '97?<br>Or do you mean that you have to maintain the data in version 2 and still be able to use it in version '97?<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.

 

[AlexUK]

hi doug<br><br>er i think i am not making myself clear- again.<br><br>i have created a database which the client has already started using. i have subsequently altered the structure of the database to include more funcionality and fixed a couple of bugs.<br>what i need to know is how to implement the upgrades with the minimum of hassle.<br><br>i have added relationships, fields to tables and queries. <br><br>thanks<br><br>Alex

 

[DougP]

OK, so they have existing data and you want to give them a new .MDB but when you do all of their data will be gone.<br><br>First make a backup of the old database.<br><br>I would create a set of import routines to Import their existing data into the new database. And leave the old database alone.<br><br>Did they make their own customer queries or reports? These you can import.<br><br>Also did you give them an .MDE or an .MDB<br>I would highly suggest you give them a .MDE so they can't tamper with or steal your work. Also its more robust. <br><br>See my FAQ's on .MDE's<br><br>What is an .MDE<br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4089324&CFToken=4008641#91"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4089324&CFToken=4008641#91</A><br><br>How

to make an .MDE<br><A HREF="

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4089324&CFToken=4008641#90"

TARGET="_new">

http://www.tek-tips.com/faq.cfm?spid=181&page=1&CFID=4089324&CFToken=4008641#90</A>

<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.