Search results

Thanks for replies dbs is currentdb The sql is a quick as I can make it - its got indexes where required. I guess the bit I am stuck on is the options when opening a recordset and the effect they have on the data (locking etc) I know I only need dbForwardonly but what effect do the types have...

Have you tried importing to a new table and seeing how access set the table field types. I would GUESS its a large number into too small a field type eg a number >32767 into an Integer field.

Not sure if this helps but could you paste the info into a duplicate table and show this table on a tab page or another form and then do an append into your master table? (Remembering to delete the temp data)

Hi, I have a database where I want to run a query and pass through the records appending field data them to class module variables. This works fine but seems quite slow (there is a lot of financial data). The question is what is the absolute fastest way to open a recordset? At the moment I am...