SQL Custom Data Types Not Visible In Access Linked Tables

  • Thread starter MileHighInDenver
  • Start date
M

MileHighInDenver

One of our applications is being upgraded -- both hardware and software. It
is moving from SQL 2005 to SQL 2008. I have an Access 2003 DB that connects
to the SQL Db via an ODBC connection. It appears that the upgraded DB from
the vendor on SQL 2008 had some table changes including the use of *alot* of
Custom Data Types. The problem I have is that when I link the tables in
Access, the only fields in the linked table that are visible are those with
the standard data types. Those fields with User Defined Data Type in the SQL
table are not visible. Is this an issue with Access not recognizing these
User Data Types? If so, is there a way in Access (maybe using VB) to recast
the fields during the ODBC call to a data type Access would recognize? I
replicated this issue on a box with Access 2007 as well. Thank you.
 
K

Klatuu

the transformation will have to take place at the SQL Server level. I would
suggest you create Views that do the transformation and link to the View
instead of the table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked tables to SQL 1
Access 2007 to SQL 2008 - primary and foreign key types 3
How do I clear a form? 0
Help creating a search form in Access XP 0
Adding data to MS Access from csv file 0
How to Upgrade SQL back end of Access linked tables. 7
Linked tables Access 2007 10
Conneting to SQL server, Need advice 4

Top