In addition, linked tables return all records to the application, which kind of negates one of the main reasons for using a database server (returning only the data you request).

I've got an Access 2003 database linked to a SQL Server 2000 database. In SQL Server (Enterprise Manager) - the field is listed as:Data Type: text, Length: 16, Allow Nulls = YesIn Access, the ...