You do not specify whether your problem occurs with Access97 or Access2000,
I assume the latter.
1) There are earlier postings about problems using Access2000 and MyODBC.
2) When using Access, performance is much better when you use a dsn-less
connection (your pseudo code seems to suggest that you do).
3) instead of calling the update after every single record insert, use
"record.UpdateBatch" after all records (or a block of records) has been
inserted. (Must open recordset with the keys: adOpenKeyset,
adLockBatchOptimistic defined as:
Const adLockBatchOptimistic= 4
Const adOpenKeyset= 1
See: ADOVBS.inc file if you have it).
Hope this helps
----- Original Message -----
From: Shawn Tagseth <stagseth@stripped>
Sent: Wednesday, 06 October, 1999 11:33 PM
Subject: [Off Topic]MS Office 2000
> I know this is OT, but just wondering if anyone else has seen this (I
> don't belong to any other mailing lists that may have windows
> programmers on it)....
> I wrote a little program in VBA and Access '97 to suck up a 30MB log
> file and pop it into a database so that I can analyze it using SQL.
> I switch over to windows NT and Office 2000. Using an exact copy of the
> (converted)database everything slows down by about 3000 percent (It
> takes the office 97 version about 4 minutes to import it and after 20
> minutes in Office 2000, it only did 23%). I think, "OK I'll try ADODB
> intead, it should be the native to Office 2000". Same thing, BUT with
> task manager running at the same time I see my memory usage go from 50MB
> to 90MB while it is running (kill it, office, and memory still didn't
> come back down)!! I also noticed that when you use ADO, the MDB file
> grows in leaps and bounds. (When the import got to 23% the db file was
> about 70MB. I stopped it and used "Tools", "Compress database" and that
> brought it down to 5MB).
> I went back to office 97 just to be sure and it worked fine. Sound
> familiar to anyone?
> The program is simple (psuedo code:)
> OpenDB = currentdb
> Open recorset = table in db
> open text file
> readline of text file
> parse text file into 5 fields
> .addnew record
> ![field1]=xxxx, ![field2]=yyyyy, etc
> .update database
> read next line of text file unitl EOF
> close recordset and db
> Shawn K. Tagseth
> BBM Bureau Of Measurement
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread753@stripped
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.