Hi,
What's the difference between VarChar, Text and Memo in Microsoft Access ?
Regards, MadSeb
+2
A:
According to this page
- Access Text is equivalent to sql server VARCHAR
- Access Memo is equivalent to sql server TEXT
renick
2010-07-27 16:59:12
what about Access VARCHAR ??
MadSeb
2010-07-27 19:19:27
Does access have a VARCHAR type? I thought that was just in SQL server. You can have Unicode fields in access but they don’t have their own type like NVARCHAR –v- VARCHAR. Other than that I cant add to the answer renick gave
Kevin Ross
2010-07-28 07:14:38
yep I can do this in Microsoft Access : ALTER TABLE MYTABLE ALTER COLUMN MYCOLUMN VARCHAR(255)
MadSeb
2010-07-28 13:21:30