<div>
I tried using dbappendonly but it for some reason wont let me add new records using .addnew
</div>


I tried using dbappendonly but it for some reason wont let me add new records using .addnew

<div>
this will only load the tablestructure and no records<br />
--&gt; u can try it by moving to the first record and displaying it - it wont work.<br />
<br />
So u can only append data to it.<br />
<br />
cheers<br />
Ricky
</div>


this will only load the tablestructure and no records
--> u can try it by moving to the first record and displaying it - it wont work.

So u can only append data to it.

cheers
Ricky

<div>
Worked like a charm.<br />
<br />
Thanks
</div>


<div>
strange,<br />
i only received email-notif 10 minutes ago...<br />
<br />
thanx for the 'A'-grade, billy21,<br />
<br />
c u later,<br />
Ricky
</div>


strange,
i only received email-notif 10 minutes ago...

thanx for the 'A'-grade, billy21,

c u later,
Ricky

<div>
<div class="content wysiwyg-content">
I have a dao recordset with over 100 thousand records in it. &nbsp;I don't need to read or edit these records in my recordset I only wish to add new records. &nbsp;I think a lot of time is wasted when I run this recordset because it loads so many records.<br />
<br />
How can I initiate my recordset so that it loads no records?
</div>
</div>


I have a dao recordset with over 100 thousand records in it.  I don't need to read or edit these records in my recordset I only wish to add new records.  I think a lot of time is wasted when I run this recordset because it loads so many records.

How can I initiate my recordset so that it loads no records?

Write only dao recordset

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.