Re: SQL Svr 2005 nvarchar(MAX) get linked as TEXT fiields in Access 03
- From: "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
- Date: Sat, 5 Apr 2008 01:41:58 -0400
There are problems with the support for nvarchar(max) in Access 2003.
Replace this type with NTEXT and you should be OK.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)
"Marge" <Marge@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B8E162DC-217B-43C5-8290-9BB98BC8A85D@xxxxxxxxxxxxxxxx
Hi, We have moved our Access 2003 database to SQL Server 2005. A number of
the original tables contained MEMO fields and these became nvarchar(MAX)
fields in SS 2005. We continue to use the original Access application and
therefore have linked the tables to the Access application via ODBC
connection. However, the fields that were originally of type 'Memo' in
Access
native tables are brought over as TEXT fields (255 char limit) by the
linking
process.
Is there a way I can link the tables and have those big text fields be
Memo
fields in the linked tables?? Or is there some way to work around this?
(Moving to Access 2007 is not an option at this time.) I would really
appreciate any suggestions! I have looked briefly at using a project but
it
looks like I would have to make a lot of changes to the forms to go that
way.
For now, I would really like to use linked tables.
Thanks.
--
Marge
.
- Follow-Ups:
- References:
- Prev by Date: SQL Svr 2005 nvarchar(MAX) get linked as TEXT fiields in Access 03
- Next by Date: Re: SQL Svr 2005 nvarchar(MAX) get linked as TEXT fiields in Acces
- Previous by thread: SQL Svr 2005 nvarchar(MAX) get linked as TEXT fiields in Access 03
- Next by thread: Re: SQL Svr 2005 nvarchar(MAX) get linked as TEXT fiields in Acces
- Index(es):
Relevant Pages
|
|
