Re: Fastest record create method with JET 4.0
- From: "William \(Bill\) Vaughn" <billva@xxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 11 Sep 2006 16:00:35 -0700
And you've chosen JET because? Where is the data sourced? Have you
considered replication? Data can replicated to SQL Server Everywhere from
SQL Server 2000 MSDE and up or SQL Server 2005 Workplace and up.
JET (even DAO) does not have a bulk import facility. SQL Server Express
does. Access does...
--
William (Bill) Vaughn
President and Founder Beta V Corporation
Redmond, WA
(425) 556-9205
Microsoft MVP, Author, Mentor
Microsoft MVP
"pauladams777" <pauladams777@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D3BBF3E1-409E-4E21-A740-C95279F4944D@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Re: Very bad response time from stored procedure call via ADO
- Next by Date: Re: Is msado15.dll different across Windows operating systems?
- Previous by thread: Re: Very bad response time from stored procedure call via ADO
- Next by thread: Re: Fastest record create method with JET 4.0
- Index(es):
Relevant Pages
|
|
