postgreSQL temporary tables and Access

Z

Zlatko Matiæ

I tried to work with postgres temporary tables from MS Access, but
unsuccessfully...
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,

Zlatko
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems allowing users to create temporary tables. Insufficientpermissions. 0
ODBC link to PostgreSQL 0
Table Security in Access 2013 1
Performing a Query from SQL Server Against Access? 1
Access Queries->fundamental data->modify ->Monthly-Report-Form in 1
Application Databases & Query Databases 1
Unbouns text box, text >255, MS Access/PostgreSQL 0
Access to Excel 2

Top