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 <ring...@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<http://www.postgresql.org/mailpref/pgsql-general>
>
