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,
pgsql-interfaces by date
|Next:||From: jing han||Date: 2005-07-28 15:18:13|
|Subject: about postgres performance issue|
|Previous:||From: Scott Cain||Date: 2005-07-18 17:06:26|
|Subject: DBD::PgSPI killing server connection|
pgsql-general by date
|Next:||From: Michael Fuhr||Date: 2005-07-24 12:11:56|
|Subject: Re: \dt gives ERROR: did not find '}' at end of input node|
|Previous:||From: NTPT||Date: 2005-07-24 11:50:38|
|Subject: \dt gives ERROR: did not find '}' at end of input node |