Access

Question

Access

VM-723206

SSCrazy

Points: 2964
More actions
June 24, 2009 at 9:16 pm

#384844

Comments posted to this topic are about the item Access

Viewing 15 posts - 1 through 15 (of 20 total)

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

Mighty SSCrazy Eights Points: 9063 More actions · Answer 1

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...

craigpessano SSCertifiable Points: 5358 More actions · Answer 2

Michael Kipp (6/25/2009)
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...

It's not just you... I read it the same way and as a result answered nvarchar.

Richard Driscoll SSCommitted Points: 1541 More actions · Answer 3

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

dmbaker SSCertifiable Points: 5139 More actions · Answer 4

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

Irish Flyer SSCrazy Points: 2245 More actions · Answer 5

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

LostAccount SSCarpal Tunnel Points: 4951 More actions · Answer 6

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

Mighty SSCrazy Eights Points: 9063 More actions · Answer 7

Irish Flyer (6/25/2009)
Who cares?? What does Access have to do with REAL databases?

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

Andrew Watson-478275 SSCarpal Tunnel Points: 4652 More actions · Answer 8

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.

jritson Ten Centuries Points: 1007 More actions · Answer 9

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.

Mighty SSCrazy Eights Points: 9063 More actions · Answer 10

Andrew Watson (6/25/2009)
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.

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!;-)

OCTom SSChampion Points: 11785 More actions · Answer 11

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.

Cliff Jones SSChampion Points: 10547 More actions · Answer 12

dmbaker (6/25/2009)
Gawd, I feel awful for actually knowing the answer. :sick:

I got this one wrong. I can live with that.

knechod SSC-Addicted Points: 482 More actions · Answer 13

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

--
Please upgrade to .sig 2.0

JF1081 SSC Eights! Points: 982 More actions · Answer 14

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