Hi David,
Are you sure you're talking about Access '97 and not
Access 2000? I didn't know you could link to SQL
Server tables with Access 97. Just in case you mean
Access 2000 you should be aware that anyone using MS
Access 2000 to gain access to SQL Server 2000 needs to
apply an update from Microsoft:
http://officeupdate.microsoft.com/2000/downloaddetails/accsql.htm?FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D26675%26redirect%3Dno
Without the update, things get "weird" to say the
least when trying to working with SQL Server 2000.
Kind Regards,
Eron
-----Original Message-----
From: David Cummins [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 11:16 PM
To: CF-Talk
Subject: OT: Access 97 and SQL 2000
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
