S
Steve
I have split my database with the tables on a remote shared drive. It's a
fairly simple customer tracking application that I want to update
periodically from an Excel Spreadsheet. I have set up a Dowhile/loop within
the updating procedure that steps through each row in xls and opens a
recordset where the custId equals the selected cell. I then update the
customer table from the spreadsheet. Splitting the database has really slowed
things down. Would it be faster to open a recordset with no WHERE clause
outside the loop and use the findfirst method within the loop to locate
records? The table has about 1500 records.
fairly simple customer tracking application that I want to update
periodically from an Excel Spreadsheet. I have set up a Dowhile/loop within
the updating procedure that steps through each row in xls and opens a
recordset where the custId equals the selected cell. I then update the
customer table from the spreadsheet. Splitting the database has really slowed
things down. Would it be faster to open a recordset with no WHERE clause
outside the loop and use the findfirst method within the loop to locate
records? The table has about 1500 records.