Access

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » Access

21 posts, Page 1 of 3

1 2 3 »»»

Access

Rate Topic

Display Mode

Topic Options

Author

Message

VM-723206

Posted Wednesday, June 24, 2009 9:16 PM

SSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263

Comments posted to this topic are about the item Access

Post #741510

Mighty

Posted Thursday, June 25, 2009 6:00 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:33 AM
Points: 2,723, Visits: 987

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

Post #741732

craigpessano

Posted Thursday, June 25, 2009 6:02 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:09 PM
Points: 4,005, Visits: 1,486

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.

Post #741735

Richard Driscoll

Posted Thursday, June 25, 2009 6:17 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, June 20, 2011 10:51 AM
Points: 1,483, Visits: 354

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

Post #741742

dmbaker

Posted Thursday, June 25, 2009 6:58 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 6:37 AM
Points: 503, Visits: 2,500

Gawd, I feel awful for actually knowing the answer. Sick

Post #741771

Irish Flyer

Posted Thursday, June 25, 2009 7:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 08, 2012 7:51 AM
Points: 1,219, Visits: 225

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

Post #741774

David Harder

Posted Thursday, June 25, 2009 7:12 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 7:11 AM
Points: 3,551, Visits: 923

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

Post #741790

Mighty

Posted Thursday, June 25, 2009 7:23 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:33 AM
Points: 2,723, Visits: 987

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

Post #741805

Andrew Watson-478275

Posted Thursday, June 25, 2009 7:25 AM

SSC Eights!

Group: General Forum Members
Last Login: Saturday, May 18, 2013 1:44 AM
Points: 953, Visits: 1,875

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.

Post #741807

jritson

Posted Thursday, June 25, 2009 7:33 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, July 16, 2010 2:10 AM
Points: 863, Visits: 295

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.

Post #741812

« Prev Topic | Next Topic »

21 posts, Page 1 of 3

1 2 3 »»»

Permissions