Re: merge multiple databases

From: DIOS (sindizzy.pak_at_softhome.net)
Date: 05/11/04 

Date: Tue, 11 May 2004 00:00:24 GMT

Yes, its only once in a while so like you said i may just stick
to the record looping process i described. Thanx.

AGP 

-- 
**********************************************************************
Unpak my email address before sending me personal email
**********************************************************************
"Ken Halter" <Ken_Halter@Use_Sparingly_Hotmail.com> wrote in message
news:%23m1%23JbrNEHA.640@TK2MSFTNGP12.phx.gbl...
> DIOS wrote:
> > The database merge is going to be done completely through code.
> > The end user does not even know that that databases are Access97
> > databases. I will keep the same table structure in the new database.
> > I just want to dump all database records into the new database but
because
> > some IDs may be the same then i just want to account for that. Again,
> > i have a plan but its based on iterating through each record. There
should
> > be
> > an easier way to do this.
> >
> > AGP
>
> There is no easier way (afaik). How often to you need to do this? If
> only once in a while, efficiency shouldn't be an issue. Reliability and
> control are far more important (imo) for these 'once in a while'
> operations. If you need to worry about over-writing specific records,
> there is no better way than to have code look at each record.
>
> -- 
> Ken Halter - MS-MVP-VB - http://www.vbsight.com
> Please keep all discussions in the groups..

Relevant Pages

  • Re: question about Workspaces(0).OpenDatabase
    ... Unpak my email address before sending me personal email ... As a test I wrote a short VB6 program that uses the same lines of code to access the database, as well as the same user-defined functions, and it works. ... This is why I believe there are some components/references missing in the server that are in my computer. ...
    (microsoft.public.vb.database.dao)
  • Re: merge multiple databases
    ... Unpak my email address before sending me personal email ... I will keep the same table structure in the new database. ... >> AGP ...
    (microsoft.public.access.queries)
  • Re: merge multiple databases
    ... Unpak my email address before sending me personal email ... I will keep the same table structure in the new database. ... >> AGP ...
    (microsoft.public.vb.general.discussion)
  • Re: GetAttr Fails on directory (Does this stump you)
    ... "Randy Birch" wrote in message ... >: AGP ... Unpak my email address before sending me personal email ...
    (microsoft.public.vb.general.discussion)
  • Re: GetAttr Fails on directory (Does this stump you)
    ... "Randy Birch" wrote in message ... >: AGP ... Unpak my email address before sending me personal email ...
    (microsoft.public.vb.winapi)
Loading