I'm running an application written in Access 2K.
It has a split front/back end.
My InternetData table is on a MS SQL server
My Parts4Sales and ComponentMaster tables are Access mdb files.
The following query appends about 250,000 records and takes about 20 minutes to run. I need to speed it up.
I've been told I need to create a stored procedure or a pass through query.
First question, is this possible in as only one of the tables is on the MS SQL server
Second, if yes, will I get better performance out of the stored procedure or pass through?
Third, how can I find out how the SQL table is connected to the database. I set it up myself, but it was years ago.