Linked Sql datatype text shows as Memo in Access 2003

I tables in Sql, which I am linking to in Access. I have a couple of
fields which are using the data type "text". Why are these appearing
as the data type "Memo" in Access.

Re: Linked Sql datatype text shows as Memo in Access 2003

The text datatype in sql server is equivalent to the memo datatype in
Access. Varchar (or nvarchar or char) is the sql server equivalent of
the Access text datatype.

Rich

*** Sent via Developersdex http://www.developersdex.com ***