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

Database Maintenance

P: n/a
jpr
Hello friends,

I would like some help or adivice on the way I will maintain my
database.
Once my work is finished I am planning to split the database.
It may happen that I will need to make changes to both files, meaning
the one with the tables and the one the forms, queries, etc.
Since I am sharing my program with different offices, there will always
be a couple of tablmes of which I will need to keep the data and
transfer it from the old database to the new one which I will update.
Is there a way to this (ex. move the data from one database to the
other)? Thanks.

Oct 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 2 Oct 2006 22:52:32 -0700, "jpr" <jp***@tin.itwrote:

When you want to release a new version that requires a back-end design
change, write the code to make that change in the front-end. To
support this it's handy to have a version number in the back-end.
Use code like CreateField, CreateIndex etc to make the db changes.

Pseudo-code:
if GetBackEndVersion() < 2 then
UpgradeBackEndToVersion2()
SetBackEndVersion(2)
end if

-Tom.

>Hello friends,

I would like some help or adivice on the way I will maintain my
database.
Once my work is finished I am planning to split the database.
It may happen that I will need to make changes to both files, meaning
the one with the tables and the one the forms, queries, etc.
Since I am sharing my program with different offices, there will always
be a couple of tablmes of which I will need to keep the data and
transfer it from the old database to the new one which I will update.
Is there a way to this (ex. move the data from one database to the
other)? Thanks.
Oct 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.