I have used the AttachDSNLessTable function from the Microsoft knowledge base article: 892490.
Just Google: Access DSNless connection 892490
Cut the function and paste the function. Then you can call it from you application and use the fact that
it provides for the tables alias (local) name to smooth out the difference between linked table naming
conventions ("mytable" instead of "public_mytable"(PostgreSQL) or "dbo_mytable"(SQL Server), or
"myuser_mytable"(oracle)).
Jonathan Blitz wrote:
> I have an Access project linked to a PostgreSQL database (linked tables).
>
> I need to be able to switch dynamitically between one PostgreSQL database
> and another according to the request from the user.
>
> Anyone have any code that will do this?
>
> I assume it will require me to re-link all the tables.
>
> Jonathan Blitz
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq