data speed

C

chriske911

witch is the fastest connection possible in VBA?
ado, dao or just plain jet using the standar access controls?

and how can I update linked tables in VBA using that connection?
it is a split database

I ask this because I have to import a comma delimited file
this holds the records for the main table and the subtable as well
in a sequential order but without a unique field to bind them

either I have to make up something myself or...
just add an autonumber to the main table
and a way to link the subrecords to that autonumber

thnx
 
Top