Access misunderstanding - MAYDAY!!!
-
MS ACCESS HELP Listing -> "If the DataType property is set to Text, enter a number from 0 to 255. " Anybody know how to deal whit this, to make it higher than 255?:wtf: Or maybe how to set Memo type at least? Regards!
Access' text datatype (Varchar in oledb terms) is limited to 255 characters (unicode). the 'memo' field type (LongVarChar) holds up to 63,999 characters. You set the field datatype when you create the table. Some databases allow the type to be changed with "Alter table". There are restrictions on what changes can be made whithout losing data, not sure what access supports.
-
Access' text datatype (Varchar in oledb terms) is limited to 255 characters (unicode). the 'memo' field type (LongVarChar) holds up to 63,999 characters. You set the field datatype when you create the table. Some databases allow the type to be changed with "Alter table". There are restrictions on what changes can be made whithout losing data, not sure what access supports.
Rob Graham wrote:
You set the field datatype when you create the table.
It's obvious;)
Rob Graham wrote:
There are restrictions on what changes can be made whithout losing data
There is no data in table, and the goal is, how to set the memo datatype? There is no option to choose memo, so how to do it? Aby ideas? Regards
-
Rob Graham wrote:
You set the field datatype when you create the table.
It's obvious;)
Rob Graham wrote:
There are restrictions on what changes can be made whithout losing data
There is no data in table, and the goal is, how to set the memo datatype? There is no option to choose memo, so how to do it? Aby ideas? Regards
eMtek wrote:
There is no option to choose memo, so how to do it?
In the Table Designer, next to the Field Name is a Data Type column. Click in it, and you will have a drop down arrow on the right side. Click it, and choose Memo. It's obvious. :)
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters
-
eMtek wrote:
There is no option to choose memo, so how to do it?
In the Table Designer, next to the Field Name is a Data Type column. Click in it, and you will have a drop down arrow on the right side. Click it, and choose Memo. It's obvious. :)
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters
EricDV wrote:
Click it, and choose Memo.
Yeah I know it's obvious;P But..., the problem was with translation (in mine Access "memo" is as a "note") used in Access. Datatype's name in any way points to memo datatype for me. So, I was confused, but now I konow. :doh: Thanks