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 wrote:
> On 09/17/2011 03:51 PM,
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/
I develop a software product in msAccess, connecting a shared database
on SQL Server, on a MS Windows Server machine.
Recently i decided to enhance my product, porting the database to
Postgresql 9.0, on an Ubuntu 10.0 Server machine.
My software works on the db mainly connecting tables via OD
