Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 25th, 2004, 07:12 AM
Registered User
 
Join Date: Dec 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with memo field in Access 97

I have upsized an Access 97 back-end to SQL-Server 2000. I have attached the tables in the front-end. Access 97 sees the memo fields in SQL-Server as text field. If a record has a memo field greater than 255, Access shows #error on all fields in that record.

Has somebody any suggestion?

Thanks,
Ardeshir Amini

 
Old December 26th, 2004, 12:21 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

You may want to convert that field to and ntext

Jaime E. Maccou
 
Old December 26th, 2004, 07:02 PM
Registered User
 
Join Date: Dec 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have already tried other types (text, ntext, nvarchar).

Ardeshir

 
Old December 27th, 2004, 01:27 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Is it showing the #error on the tables or your forms or reports?


Jaime E. Maccou
 
Old December 27th, 2004, 06:05 AM
Registered User
 
Join Date: Dec 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It shows on tables.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Vb6 access 97 recordset problem Probie VB Databases Basics 3 August 1st, 2007 06:12 PM
Inserting data into an Access memo field with SQL jhunta VB How-To 3 September 20th, 2005 02:49 PM
testing for empty Access memo field RDEdwards Classic ASP Databases 3 November 9th, 2004 09:03 AM
Access update memo field problem mar0364 Access ASP 0 March 25th, 2004 04:03 PM
Access 97 Date format problem Andrew Antoniak Access VBA 2 February 21st, 2004 12:47 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.