Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
I am trying to export Ms Access table to a Postgres Database. I have written a Macro in Access. The macro just has one action - TransferDatabase.
It executes successfuly, however when the macro runs it prompts me to select the ODBC driver everytime. How could I stop the macro from prompting me to select the ODBC driver?
I am using the following connection string
ODBC; [DSN=PostgreSQL; SERVER=pc-00131;] [DATABASE=erp;] UID=xxx; PWD=xxx
Is there any change that I have to make in my connection string ???
Your help would be greatly appreciated.
Viv
I am trying to export Ms Access table to a Postgres Database. I have written a Macro in Access. The macro just has one action - TransferDatabase.
It executes successfuly, however when the macro runs it prompts me to select the ODBC driver everytime. How could I stop the macro from prompting me to select the ODBC driver?
I am using the following connection string
ODBC; [DSN=PostgreSQL; SERVER=pc-00131;] [DATABASE=erp;] UID=xxx; PWD=xxx
Is there any change that I have to make in my connection string ???
Your help would be greatly appreciated.
Viv
