What is slow about my code? Recordset to update table column

**Broker15** · 10-09-2014, 11:19 AM

What is slow about my code?

In a lot of my projects I create functions that are entered into recordset sql as parameters. Ultimately I want to update a column in access with a custom function looping through each record, and I have not figured out the best way. As of now i am running this function through a make table query. Thanks Everyone!

Please Login or Register  to view this content.

**Broker15** · 10-09-2014, 11:22 AM

Oh I forgot to mention. This is searching through 80,000 + records. It takes about 10

**pareshj** · 10-09-2014, 11:26 AM

Hi,

Your code looks OK. I think you need to check with query in the code. Just check if you can optimize the same.

Regards,
Paresh J

What is slow about my code? Recordset to update table column

LinkBack

Thread Tools

Rate This Thread

Display

What is slow about my code? Recordset to update table column

Re: What is slow about my code? Recordset to update table column

Re: What is slow about my code? Recordset to update table column

Thread Information

Users Browsing this Thread

Similar Threads

ADO Recordset Update

Code to update all pivot tables in a workbook is slow

pivot table from recordset - slow performance

pivot table from recordset - very slow performance

Update a record in the recordset

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions