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

Updating tables and forms

P: n/a
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

May 21 '07 #1
Share this Question
Share on Google+
2 Replies

P: n/a
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
May 24 '07 #2

P: n/a
Thanks for suggestions.

May 24 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.