Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eltonwheelock
Starting Member
5 Posts |
 Posted - 2010-10-14 : 17:06:12
|
| We have an old Access app that uses an ODBC connection to SQL for a backend. The SQL database used to be access, and was converted, but many of the fields were left as TEXT data type. We are in the process of redeveloping the Access app, but we also need to implement some triggers on the tables in the meantime - and I cannot create a trigger on a table that has TEXT columns.I have read that VARCHAR(MAX) is an equivalent replacement for TEXT. However, when I made the change, Access was no longer able to write to the columns. What's really strange is that no errors were thrown, the app thinks it wrote to the field, but the data wasn't there. Something's not adding up, and my question to the forum is, has anyone else had a similar issue with Access connecting to SQL via ODBC and/or with the TEXT vs. VARCHAR issue. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
|
|
|
MS Access using ODBC to MSSQL - TEXT vs. VARCHAR