Question Locked

MS ACCESS 2003 ADP SQLServer2000 Can't see data in Tables

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have attempted to set up an ADP connection to a custom ERP systems's SQL Server DB which uses Custom Data Types throughout all tables. I can see table design and stored proceedure design but can't see any data in tables or run any stored proceedures against these tables.

I have tested other databases on the same SQL server with the same login account so security is not the issue. The only thing I can find unique about this database is that every field utilizes a custom data type.

ODBC connections to this same SQL server DB tables are sucessfull and all data is visible. I have a feeling it may have to do with "extended properties"...when setting up the ADP connection in the ADP wizard, I am not sure if there is a parameter I can pass to allow the use of these and what the syntax is.

Has anyone else run into this anywhere and if so is there a workaround? I have asked the vendor of the SQL server DB but they did not have any answers and suggested that I ask Microsoft.....enough said on that! I searched all of MSDN etc...with no luck finding anything.

Any insight would be greatly appreciated!

1 reply

This discussion is closed to new replies.