Re: problem connecting postgresql 9.0 tables from vba

[c k <shreeseva.learning@xxxxxxxxx>]

why didn't you use 
    Set TD = CurrentDb.CreateTableDef(stLocalTableName, dbAttachSavePWD, stRemoteTableName, stConnect)
    CurrentDb.TableDefs.Append TD

to link to a new table and then do your work.

C P Kulkarni

On Sun, Sep 18, 2011 at 4:32 AM, Craig Ringer <ringerc@xxxxxxxxxxxxx> wrote:

On 09/17/2011 03:51 PM, Adriano V. Autino wrote:

Therefore I use a docmd.transferdatabase acLink method, that works perfectly on SQL Server.

When you say it fails: What's the full, exact text of the error message?

What SQL, if any, is sent to the server? (Enable "mylog" on the ODBC driver and/or enable query logging on the server).

--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general