Re: Fastest record create method with JET 4.0


pauladams777 wrote:
I need advice on the fastest method for adding data to an existing Access
database.

Dramatically simplified, I have an application written in C++ that need to
push records into an existing Access database.

Due to the increased size of the install, I wish to avoid the need for the
Access Runtime, and so am trying to use the Jet 4.0 engine.

Basically, all my application does with the Access database is connect, open
the table, add a record, fill in the field values, save the record, close the
table and disconnect. (I actually add lots of records in each table open /
connection, but that isn't the point.)

Currently I use ADO to connect to Jet 4.0. However, I have found that the
speed is really slow compared to other databases I am using. I understand
that DAO would be faster, as it is Access / Jet specific.

However, I can't find any DAO specific discussion group.

Can anyone give me some pointers (or pointers to information sources) on the
very basics of how to approach use of DAO - I haven't got the first clue.

Hummm. I might have something here on my hard disk about that.....

Ah, here it is: DAO vs ADO. I do not know who wrote it, but it might
have come from Microsoft. I have placed the project at
http://holysmoke.org/temp/daovsado.zip

The project uses either DAO or ADO to perform various functions
specified by command buttons, and it places the time it took to
complete in the main form's .Caption property. DAO does appear to be
faster, and the sample project will give you an idea on how DAO is done.

.