SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by VM / Access / Latest Posts

RE: Access

manik123 — Fri, 01 Feb 2013 06:00:34 GMT

[quote][b]David Harder (6/25/2009)[/b][hr]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'?"[/quote]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".

RE: Access

kalyani.k478 — Fri, 02 Nov 2012 03:54:53 GMT

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

RE: Access

Bhavesh_Patel — Fri, 11 Dec 2009 03:53:06 GMT

I to got wrong

RE: Access

renat ka — Tue, 15 Sep 2009 03:54:30 GMT

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

RE: Access

Mark Dalley — Fri, 26 Jun 2009 04:52:54 GMT

[quote][b]knechod (6/25/2009)[/b][hr][quote][b]David Harder (6/25/2009)[/b][hr]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'?"[/quote]I see I'm not the only one to read the question that way! Another vote for points!Kevin[/quote]Me too. The question contains an ambiguous inner join, I would suggest.MarkD

RE: Access

SMGarner — Thu, 25 Jun 2009 12:45:00 GMT

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 andSQL Data Typeshttp://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. :-)

RE: Access

JF1081 — Thu, 25 Jun 2009 11:14:54 GMT

I read it and figured it could be answered both ways so I had a 50 - 50 change to get it right. I chose TEXT data type in Access = NVARCHAR data type in SQL

RE: Access

knechod — Thu, 25 Jun 2009 11:05:03 GMT

[quote][b]David Harder (6/25/2009)[/b][hr]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'?"[/quote]I see I'm not the only one to read the question that way! Another vote for points!Kevin

RE: Access

Cliff Jones — Thu, 25 Jun 2009 08:46:21 GMT

[quote][b]dmbaker (6/25/2009)[/b][hr]Gawd, I feel awful for actually knowing the answer. :sick:[/quote]I got this one wrong. I can live with that.

RE: Access

OCTom — Thu, 25 Jun 2009 08:45:36 GMT

There are two "text" type fields in Access: Text and Memo. That's the way I read it.But, I thought we were'nt supposed to use the SQL Server TEXT data type anyway.

RE: Access

Mighty — Thu, 25 Jun 2009 07:37:32 GMT

[quote][b]Andrew Watson (6/25/2009)[/b][hr]I'm with David on this one. The question as written is totally ambiguous, and nvarchar or memo are equally valid answers, depending on how you parse the question.[/quote]I agree on this. Anyone who gave one of both answers, should be granted the point. Because the point is what it is all about!;-)

RE: Access

jritson — Thu, 25 Jun 2009 07:33:01 GMT

I did even worse, I went into Access, opened the design of a table, saw that my character type fields are formatted "text" so opted for "text."I have to admit though, it was worth it. I now have a much better understanding of the difference between text and varchar in SQL and memo and text in Access.

RE: Access

Andrew Watson-478275 — Thu, 25 Jun 2009 07:25:24 GMT

I'm with David on this one. The question as written is totally ambiguous, and nvarchar or memo are equally valid answers, depending on how you parse the question.

RE: Access

Mighty — Thu, 25 Jun 2009 07:23:08 GMT

[quote][b]Irish Flyer (6/25/2009)[/b][hr]Who cares?? What does Access have to do with REAL databases?[/quote]Not too much, so in that respect the question of matching a MS Access data type to a SQL Server data type makes even more sense, since that knowledge is needed when migrating those datatbases to real ones...:-D

RE: Access

David Harder — Thu, 25 Jun 2009 07:12:39 GMT

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'?"

RE: Access

Irish Flyer — Thu, 25 Jun 2009 07:02:50 GMT

Who cares?? What does Access have to do with REAL databases?

RE: Access

dmbaker — Thu, 25 Jun 2009 06:58:36 GMT

Gawd, I feel awful for actually knowing the answer. :sick:

RE: Access

Richard Driscoll — Thu, 25 Jun 2009 06:17:30 GMT

http://office.microsoft.com/en-us/access/HA012314471033.aspx

RE: Access

craigpessano — Thu, 25 Jun 2009 06:02:32 GMT

[quote][b]Michael Kipp (6/25/2009)[/b][hr]Maybe it's just me, but I read the question differently, looking for the SQL Server data type to match the MS Access data type. Might be that my English is not good enough...[/quote]It's not just you... I read it the same way and as a result answered nvarchar.

RE: Access

Mighty — Thu, 25 Jun 2009 06:00:15 GMT

Maybe it's just me, but I read the question differently, looking for the SQL Server data type to match the MS Access data type. Might be that my English is not good enough...

Access

VM-723206 — Wed, 24 Jun 2009 21:16:07 GMT

Comments posted to this topic are about the item [B]Access[/B]