On 21 May 2007 04:04:12 -0700, Matuag <ma****@gmail.comwrote:
Unless it's a single-user app, you need to split the db. Do it today.
If you have a working app in the field (at multiple clients) and you
want them all to upgrade to the new version, what I would do is to
write the conversion code in my startup routine. Use functions like
CreateField, CreateIndex, etc. to rev the back-end db from version 1
to 2. Would be handy if you had the foresight to keep a version number
in the back-end. Not too late for that.
If you have a single client (corporate environment), you develop the
new backend on your development machine, keep notes of what you
changed, and re-apply those changes to the production back-end at a
time (weekend) nobody is in the system. Of course by that time the new
version has been beta tested and accepted.
-Tom.
>Hi All,
Is there any easy way to replace existing table structure by new table
structure (with additional fields) without affecting data and table
relationships. How forms with new design be replaced similarly?
I have not split the database and it is in a single .accdb (Access 07)
file.
Matuag