in reply to ODBC DBI Temp Tables

I'm not sure you can use temporary tables in MS Access but IF you can it may very well suffer from this problem in the DBD::ODBC FAQ.

Replies are listed 'Best First'.
Re^2: ODBC DBI Temp Tables
by nathaniels (Acolyte) on Mar 21, 2014 at 04:16 UTC

    Thank you for that link MJE. I'll have to play around with that later and see if that helps. I may just have to give up on using a temporary table...