Hi all,
We have a client who wrote a pair of Access apps that share data over a LAN. Now
they want to move them to having a backend of SQL 2000 so they can run it over
the net (plus have online access to the data contained in the system).
The problem is, that when Access links to SQL tables, it does not seem to
recognise any text field over 255 characters as being equivalent to a Memo
field. It instead shows up in Access as a text field with 255 characters. In
fact, the Access help shows how ANSI SQL types map to Access types, and it seems
that nothing maps to a Memo field at all!
Does anybody have any idea how we can get around this? Tricking Access?
Workarounds? Newer version of Access or ODBC drivers? Help!
David Cummins
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
