By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,283 Members | 1,235 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,283 IT Pros & Developers. It's quick & easy.

updating a database with more than one version out there

P: n/a
this is a really weird issue for me to try to explain but i'll do my best. i
started writing a db for my store in september to track customer flow. at
that time, i gave a copy to 3 other of our stores to use for their benefit.
since then, i have completely changed my version to add new features like
sales tracking, salesperson perfomance and forecasting reports just to name a
few. what i need to do now is to update the 3 other store's programs without
losing their data. here is a list of the key factors.

1. the 3 old versions are not split, but now mine is front half / back half,
which i would like to do for their copies as well. i have added a cmd button
to open the linked table manager from the startup page so they can link the
tables on their own. (and when i say they, i mean the multitude of users
that range from quasi-savvy to the downright technophobe so all solutions
have to be user friendly.)

2. ALL of the original tables are still there and named the same, but there
are new fields in some of them on my db to incorporate these new features. i
need to add these fields to their tables somehow (manually is possible,
obviously, but higher probability for error so i'm hoping for a better

3. i would also like to be able to empty all of the records in my db in case
i need to give it to a completely new store. i would need to empty most, but
not all of the tables, as some are just there as source data for combo box
controls throughout the db.

4. anything else you could suggest that i do differently to facilitate this
in the future without having to repost.

sorry for the haphazard way in which this question was asked but i wasn't
sure how to concisely explain my issues. thanks for the help.



Message posted via
Apr 19 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.