Re: merge multiple databases

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

Date: Fri, 14 May 2004 23:08:03 GMT

Well, as YYZ said, I myself tried built in queries in the Access database
but did not notice much difference. Maybe there is a difference on bigger
databases but mines is for a home program with maybe like 50 to 100 thousand
records. Also, since the user does not even know that the database is an
Access
databases, I need to do everything through DAO. At this point I dont want to
mess
around with inseeting queries in Access and then running them from there.
For
the moment the results were satisfactory. The test I maded was probably an
extreme
end so im looking at 20 to 60 seconds for the user to merge his databases.
i aslo walk him through every step and I dont think they are going to
complain.

Thanx
AGP 

-- 
**********************************************************************
Unpak my email address before sending me personal email
**********************************************************************
"Jim Carlock" <anonymous@127.0.0.1> wrote in message
news:Ool2breOEHA.2952@TK2MSFTNGP12.phx.gbl...
> I think there are other things that might play into it as well.
> When I did it, it was through an ODBC connection, and
> maybe I just fell into the fact that the Internal Access query
> was faster, and perhaps it was just easier to read for me.
>
> There were a few thrings I tried but I don't remember
> exactly if that specifically was one of them. I ended up
> with an internal Access Make Table query and then a
> ton of update queries. The biggest problem I had was
> getting the download of the initial tables and I had tried
> doing selective queries but that ended up taking over 24
> hours, I tried VB SQL and decided that using the Access
> queries was much better for some reason. I left some
> VB string SQL in place for delivering the data to the
> report generator, as there were 1000s of accounts and
> some some accounts with 1000s of transactions that
> needed printing.
>
> I'm kind of hoping DIOS tries it out and gives a Yay or
> Nay.
>
> -- 
> Jim Carlock
> http://www.microcosmotalk.com/
> Post replies to the newsgroup.
>
>
> "YYZ" wrote:
> "Jim Carlock" wrote:
> > If you put the SQL into queries inside of Access, I'm thinking that
> > it should get even faster... IE make the query in the new Access file,
> > and then call that query from the VB application, with an .Execute
> > if it's an action query, or with the .RecordSet object if it's a Select
> > query.
> >
> > If the query inside of Access was named "qSelectAllRecords", then
> > you can open it with :
> >
> > Set rs = gDAO_DB.OpenRecordset("qSelectAllRecords")
>
> I've done some half assed testing with that in the past, and never really
> noticed a difference.  But again, it was half assed, so you may be right.
>
> Matt
>
>
>

Relevant Pages

  • Re: merge multiple databases
    ... Well, as YYZ said, I myself tried built in queries in the Access database ... databases, I need to do everything through DAO. ... I ended up> with an internal Access Make Table query and then a> ton of update queries. ...
    (microsoft.public.access.queries)
  • Re: merge multiple databases
    ... Well, as YYZ said, I myself tried built in queries in the Access database ... databases, I need to do everything through DAO. ... I ended up> with an internal Access Make Table query and then a> ton of update queries. ...
    (microsoft.public.vb.database.dao)
  • Re: Different MSSQL output date format from the same PHP script
    ... Especially when "SELECT *" queries just do have their uses. ... And the fact your programs and databases evolve makes it even more important to specify column names. ... You wouldn't want to ever want to, say, run a query returning all ... You may think it's not bad, but many other, more experienced programmers will tell you it is. ...
    (comp.lang.php)
  • Re: Please Help with database upate. New to database
    ... new to databases and doing alot of reading and OJT. ... search that master query. ... could be queries as long as I can export that data into excel. ... FROM tblA LEFT JOIN tblB ON tblA.Field1=tblB.Field2 ...
    (comp.databases.ms-access)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
Loading