Access

Question

Post reply

Access

Viewing 6 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

SMGarner Say Hey Kid Points: 668 More actions · Answer 1

It should be noted that the reference and notes apply to Unicode and Access 4.0.

Additional references:

Equivalent ANSI SQL Data Types

URL; http://msdn.microsoft.com/en-us/library/bb177899.aspx

and

SQL Data Types

http://msdn.microsoft.com/en-us/library/bb208866.aspx

indicate that text in MS Access 2007, Zero to a maximum of 2.14 gigabytes, equivalent to text in SQL. 🙂

Mark Dalley SSCrazy Points: 2974 More actions · Answer 2

knechod (6/25/2009)
David Harder (6/25/2009)
I missed this also because I read the question. It says "What is the equivalent of 'text' data type in MS Access?"
Although the majority are getting it "correct" I also read it to mean the other direction. The question should have been worded something like "What is the MS Access equivalent to the SQL data type 'text'?"
I see I'm not the only one to read the question that way! Another vote for points!
Kevin

Me too. The question contains an ambiguous inner join, I would suggest.

MarkD

renat ka SSC Enthusiast Points: 161 More actions · Answer 3

this question should be rewritten, becuase of the ambigious reading!

Bhavesh_Patel SSCrazy Points: 2259 More actions · Answer 4

I to got wrong

[font="System"]Bhavesh Patel[/font]

http://bhaveshgpatel.wordpress.com/

kalyani.k478 Default port Points: 1400 More actions · Answer 5

confused as Acess has both text n memo data types...Got it right though:w00t:

manik_anu SSCrazy Points: 2377 More actions · Answer 6

David Harder (6/25/2009)
I missed this also because I read the question. It says "What is the equivalent of 'text' data type in MS Access?"
Although the majority are getting it "correct" I also read it to mean the other direction. The question should have been worded something like "What is the MS Access equivalent to the SQL data type 'text'?"

There is not mention about normal text or large text. If it is normal sql data type "text" means MS access also same as "text". If it is large text means MS access data type is "Memo".

Manik
You cannot get to the top by sitting on your bottom.