Make Access Database changes in TEST then putting Live data


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Make Access Database changes in TEST then putting Live data

Hybrid View

  1. #1
    Bill Goodland Guest

    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

  2. #2
    SB Guest

    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




  3. #3
    Larry Rebich Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center