By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,335 Members | 2,258 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,335 IT Pros & Developers. It's quick & easy.

postgreSQL temporary tables and MS Access

P: n/a
I tried to work with postgres temporary tables from MS Access, but
I was able to create temporary table by pass-through query, also I succeeded
in creating linked table through code, but when I try to open it, an error
apears and Access says there is no schema...
Also, I couldn't link table using ODBC wizard...
Can someone explain why I can't use temporary tables from MS Access ? Does
it mean that every query execution is separate connection, so previously
created temporary table no longer works for next queries ?
Has anybody used postgres temporary tables from MS Access ?

Thanks in advance,

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.