Re: problem connecting postgresql 9.0 tables from vba

Поиск
Список
Период
Сортировка
От c k
Тема Re: problem connecting postgresql 9.0 tables from vba
Дата
Msg-id CAN2Y=uPy-KLi4_j2im0Cxea_aOJ0NjaikdWEQ1V+bWsbCyFCPg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: problem connecting postgresql 9.0 tables from vba  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-general
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@ringerc.id.au> 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: c k
Дата:
Сообщение: Date time value error in Ms Access using pass through queries
Следующее
От: Emanuel Araújo
Дата:
Сообщение: Problem dbi_link with postgresql 9.04