473,402 Members | 2,055 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,402 software developers and data experts.

Memo data type?

Hi,

SQL back end, Access front end. I have a table for entities and folks now want to be able to capture notes on an entity. Lengthy notes of text/numbers. I've seen on the web a SQL data type of nvarchar (max) but have never used it. Would that work? Any other options? I know Access has a memo data type but believe that is not an option in SQL or is it? Thanks.
Jan 5 '15 #1

✓ answered by ck9663

It should work. But it's always a good rule of thumb to put a limit on your comment/notes columns. That's also good on your front-end.

Good Luck!!!


~~ CK

1 1882
ck9663
2,878 Expert 2GB
It should work. But it's always a good rule of thumb to put a limit on your comment/notes columns. That's also good on your front-end.

Good Luck!!!


~~ CK
Jan 5 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Jacky11 | last post by:
When combining in a query a field with MEMO Data type and a field with TEXT Data type like this Caption: ! & ! The query will not Display/Export more than 256 characters. The field is a Memo...
3
by: Martin Lacoste | last post by:
Is there some issue with using too many left/right/mid/len functions in queries? Depending on the usage, they work fine, but... then there's here: SELECT Master_CAO.Incipit,...
0
by: mp | last post by:
Hi, I have MS Access table. I have binded this table with daraGrid and everything works. Last filed is Memo Data Type and, normaly, I can not see contents in datagrid. I would like to see...
3
by: Mejmeyster | last post by:
Hi Everyone, I have a table in which one of the text fields has become too small (since it only holds 255 characters). To remedy that, I'm trying to change the data type of that field to "memo"...
0
by: Dilruba | last post by:
I want retrieve data from Ms Access 2000 database by using ASP and data type memo and after that i want e-mail that data automatically
0
by: Dilruba | last post by:
I have tried to take Memo (Access 2000) data type in a Dim variable. After that i have send it via e-mail text. But it is not sending the vaule. Here is the code that i have used: <% Dim msgDb...
1
by: ritu raj shriwastaw | last post by:
I am using window xp and php trait(php3.1,mysql4.2).i have one field is of memo data type and I am unable to retrieve data from that memo data type field. what query I should write?
3
by: BulbFresh | last post by:
Hi, I'm using Access 2000 and importing .csv files to a table. This works very well apart from one column which sometimes will be a short note (text < 255 characters) and sometimes a long...
2
by: gina farrow | last post by:
I keep getting a message," syntax in your sub query is incorrect". For the following code: SELECT IIf(IsNull();"No";"Yes") AS ; Count(IIf(IsNull();"No";"Yes")) AS Qtd FROM Motivos GROUP BY...
0
by: suexicano | last post by:
Hi - Getting the famous Data type mismatch error with the following code. The CallComments is a Memo Data type ins Access 2007, and that is the data element causing the error. this.Cursor =...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.