rvaalst
1st April 2003, 13:49
Hi,
I tried to make an ODBC connection to a SQL Server DB.
In MS Access I want to use this connection to link a couple of Baan tables.
The ODBC connection works, I can establish a connection
But when I want to use this connection in Acces, in stead of showing me all the Baan tables I can only see the first system table in the Baan database: dbo.properties.
I tried using this connection as user baan, sa and a number of other Baan users but always the same result.
Can anyone give me hand how to solve this?
Thanks in advance,
Ronald van Aalst
I tried to make an ODBC connection to a SQL Server DB.
In MS Access I want to use this connection to link a couple of Baan tables.
The ODBC connection works, I can establish a connection
But when I want to use this connection in Acces, in stead of showing me all the Baan tables I can only see the first system table in the Baan database: dbo.properties.
I tried using this connection as user baan, sa and a number of other Baan users but always the same result.
Can anyone give me hand how to solve this?
Thanks in advance,
Ronald van Aalst