| From: | c k <shreeseva(dot)learning(at)gmail(dot)com> |
|---|---|
| To: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
| Cc: | adriano(dot)autino(at)andromedase(dot)com, "Adriano V(dot) Autino" <andromedasrl(dot)com(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: problem connecting postgresql 9.0 tables from vba |
| Date: | 2011-09-21 10:17:54 |
| Message-ID: | CAN2Y=uPy-KLi4_j2im0Cxea_aOJ0NjaikdWEQ1V+bWsbCyFCPg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)ringerc(dot)id(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emanuel Araújo | 2011-09-21 10:38:14 | Problem dbi_link with postgresql 9.04 |
| Previous Message | c k | 2011-09-21 10:08:11 | Date time value error in Ms Access using pass through queries |