Hi,

I have a SQL dbase on a SQL server and a Access 97 DB with forms.
The problem is that access 97 can't read the SQL tables wich have memo fields (text) an other table on the SQL server which has no memo fields works fine.

in access 2000 and 2002 it works perfectly but i have to use access 97.

Can somebody help me solve this problem. I tried other types of fields on the sql but it still doenst't work (cant write or delete).

Greetings,
Rednas

How are you readin SQL tables? Are you linking them to Access97? Using pass-trough queries?