Make Access Database changes in TEST then putting Live data

[Bill Goodland]

I have an Access Database with 15 or 20 tables used in VB. I have to add
a bunch of fields, change length etc. along with changing the VB programs.


What is the easiest way to relicate the "LIVE" data to my changed database
when we put it into production.


THANKS IN ADVANCE , BILL

[SB]

The way I do it:
I have a Version number in the database. My VB 6 application always checks
this version# every time it is run. If I update the database and the VB
application, I include a routine using DAO/ADOX to update the database
fields. I always ship the new VB app along with a small database that
includes new tables, etc.; I basically modify the structure of the db by
code and copy any new tables from the "small db" that gets installed with
the updates. It sounds difficult, but it's not! When the new VB app starts
and gives a warning that the db will be converted to the new version and
that's it!

"Bill Goodland" <bgoodland@bgsoftwareinc.comill> wrote in message
news:3a7b2578$1@news.devx.com...
>
> I have an Access Database with 15 or 20 tables used in VB. I have to add
> a bunch of fields, change length etc. along with changing the VB programs.
>
>
> What is the easiest way to relicate the "LIVE" data to my changed database
> when we put it into production.
>
>
> THANKS IN ADVANCE , BILL

[Larry Rebich]

Bill,

If you are using DAO then check out this tip.

Some months ago I wrote a tip of the month that I call 'Dynamically Update a
DAO Database Using a Model'. Link to http://www.buygold.net/tips.html then
look for the September 2000 tip of the month. A sample program is provided.

Cheers,
Larry Rebich

More tips link to:
http://www.buygold.net/tips.html

Please:
No personal e-mail questions :-)


"Bill Goodland" <bgoodland@bgsoftwareinc.comill> wrote in message
news:3a7b2578$1@news.devx.com...
>
> I have an Access Database with 15 or 20 tables used in VB. I have to add
> a bunch of fields, change length etc. along with changing the VB programs.
>
>
> What is the easiest way to relicate the "LIVE" data to my changed database
> when we put it into production.
>
>
> THANKS IN ADVANCE , BILL