Memo data type?

[borlowski]

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.

[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