-
Make Access Database changes in TEST then putting Live data
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
-
Re: Make Access Database changes in TEST then putting Live data
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
-
Re: Make Access Database changes in TEST then putting Live data
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|