MS Access 97: Linking Views

• TomT

  SSC Eights!

  Points: 887

  More actions

  May 27, 2003 at 10:46 am

  #101494

  Has anyone noticed this problem, and if so, what solutions have you found?

  I have an Access 97 front end, with a SQL Server 2000 backend. For some forms I have created views and linked them to the front end.

  One of the tables in these contains a varchar 5000 field. When linking the table, and then opening it in Access in design view, the field is designated as memo. That's fine.

  However a view based on this table and linked to Access, shows in design view the field as text, 255.

  My workaround for this has been to use Cast in the view to trick Access into seeing the field as memo, linking the view, then removing the Cast statement and re-linking. This does force Access to see the field as memo, but I wonder why all this is necessary.

  Any advice would be appreciated.

  Thanks,

  Tom Tucker

• May 30, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Steven Hollander

  Newbie

  Points: 5

  More actions

  June 2, 2003 at 11:42 pm

  #459452

  quote:

  ---

  We are useing MSAccess 2000 with SQL7. We have defined all large fields as TEXT rather than VARCHAR.

  This may help

  ---