Quote:
|
Originally Posted by beakmyn
move your DIM outside of the loop so you declare them once and not everytime you go through the loop.
The real memory hog and slowness is creating a hook into your database every time you want to add a record.
Instead of using opensrecordset and insert consider adding a WHERE clause to your insert statment.
|
I may be wrong, but how does one do a WHERE on a Record that doesn't exist?
If you're inserting it, then you're creating the record, you can do a WHERE in the UPDATE, but I've never see one on a INSERT.
I could be wrong, never claimed to know everything about SQL.