Unanswered: Data type problem with Sybase ODBC to MS Access 2003
I have a linked Sybase table in MS Access 2003 using Datadirect 4.2 Sybase driver. I just cannot get access to recognize the database type. All the text data type in Sybase got converted to memo via Access. Is there a work around for this. Could anyone please give me the procedure on how to resolve this issue? Really appreciated.