Wendell, thank you for the detailed response.

I've kinda been taking that approach. I've upsized the back end to SQL. Everything I've read is exactly what you've written. All of my work within the front end DB(forms, modules, etc.) will need to be tested for what's the best performance now that I've upsized the back end.

After upsizing, I tried a simple delete query.

DELETE FROM dbo_PM_Temp

The table only contains 1500 rows. It takes about 2 minutes, before Access returns the confirm message. Is that normal?

If yes, how would you handle this delete process?