[AccessD] ...building, managing, and using a page favorites list

Gustav Brock Gustav at cactus.dk
Sun Mar 8 12:19:15 CDT 2009


Hi Max

No. Working with the recordset directly via DAO is always fastest - but many forget or carry over their bad habits from VB or ASP where you see so much SQL command stuff and the like, because this once was the only - or at least the easiest - method available in those environments.

Of course, for a single record inserted, difference will not be big. But can you keep the recordset open, one insert is very speedy.

/gustav

>>> max.wanadoo at gmail.com 08-03-2009 17:24:53 >>>
> This speeds things up by keeping the recordset open the whole time.

Would it be quicked to use an SQL statement ie,
Sql = "Insert into tblAudit fields(x,y,z) values (a,b,c)
Currentdb.execute(sql)

Rather than opening recordsets.  I don't know, so i am really asking the
question

Thanks

Max






More information about the AccessD mailing list