VB.Net (ADO): Thoughts on Copying 7 tables to 1 table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mr. B (User_at_NoWhere.com)
Date: 10/21/04 

Date: Thu, 21 Oct 2004 15:18:18 GMT

2 Part Question:

I've a VB.net application where I read information from 7 Tables in a MS
Access Db. There is a performance hit when this happens (about a 1-2 second
hit per table). So I'm going to combine the relavent parts of each table into
a single table in a "new' MDB file.

I've experimented with this and found that the best way that I can see is to
gather the information from each table into an Array and then dump that info
into my new MDB file. I want all the 7 tables starting with the FIRST row in
the new table.

I first get the number of rows for a table, re-dim my array and gather the
info. Then I repeat for the next table - I compare table row lengths to make
sure my Array does not get smaller than the maximum table row found.

All appears to work fine.

Question #1:

Can someone suggest a better way (if there is one) to take the "selected"
columns from a single MDB (having 7 tables) into a new single MDB with 1
table. I tried reading each of the 7 tables into my new MDB, but this doesn't
work as each table adds new rows past the previous table information.

Question #2:
Every now and then, I find one of my columns (about mid way down) has a bunch
of NULL cells when the data should be continuous in the column. I run the
application again (maybe a third time) and all is OK. All the other columns
are OK (and the code is similar). A head scratcher for me. Any thoughts?

Thanks in advance.

Regards,

Bruce

Relevant Pages

  • VB.Net (ADO): Thoughts on Copying 7 tables to 1 table
    ... There is a performance hit when this happens (about a 1-2 second ... a single table in a "new' MDB file. ... I first get the number of rows for a table, re-dim my array and gather the ... columns from a single MDB into a new single MDB with 1 ...
    (microsoft.public.vb.database.ado)
  • VB.Net (ADO): Thoughts on Copying 7 tables to 1 table
    ... There is a performance hit when this happens (about a 1-2 second ... a single table in a "new' MDB file. ... I first get the number of rows for a table, re-dim my array and gather the ... columns from a single MDB into a new single MDB with 1 ...
    (microsoft.public.dotnet.framework.adonet)
  • Just not getting it--need help with Generate Report function
    ... spending too much time racking my brains trying to figure this ... $page_title = 'Generate Report'; ... $mdb = new mdb; ... $scols = array; ...
    (alt.php)
  • Saving a array of bytes using ADO
    ... In TADOQuery component there is no way of saving an array of bytes. ... If I manage this for mdb I think I can use the same technique for other DB using ADO components. ...
    (borland.public.delphi.database.ado)