Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I use an ODBC connection to my postgres DB, it doesn't seem to display the database tables or table fields on the "Create Select Statement" page.
Is there a limitation on the number of tables it can show ?
Very bizzare
Does the account with which you create the DB CONNECTion have enough rights to access any tables in the current DB?
Thanks for the reply Peter
Yip, the user def has the correct permissions.
If I use MSQuery in Excel I can see the tables there ?
Any ideas anyone ?