https:\/\/en.wikipedia.org\/wiki\/Microsoft_Data_Access_Components#History<\/a><\/p>\nfrom Yossi Dukes (privately):<\/p>\n
what about error trapping if the SP fails?<\/p>\n
from Giorgio Rovelli (privately):<\/p>\n
This implies you have to know T-SQL to produce sprocs<\/p>\n
from Yossi Dukes (privately):<\/p>\n
How large a varchar can ADO support from the SQL db (ie: if theres a 10k memo stored in the SQL db, can ADO return the whole contents or is there a physical limit that ADO can return; and if so, what’s the max size it can return)<\/p>\n
from Yossi Dukes (privately):<\/p>\n
char(n)\u00a0\u00a0\u00a0 Fixed width character string. Maximum 8,000 characters\u00a0\u00a0\u00a0 Defined width<\/p>\n
varchar(n)\u00a0\u00a0\u00a0 Variable width character string. Maximum 8,000 characters\u00a0\u00a0\u00a0 2 bytes + number of chars<\/p>\n
varchar(max)\u00a0\u00a0\u00a0 Variable width character string. Maximum 1,073,741,824 characters\u00a0\u00a0\u00a0 2 bytes + number of chars<\/p>\n
text\u00a0\u00a0\u00a0 Variable width character string. Maximum 2GB of text data\u00a0\u00a0\u00a0 4 bytes + number of chars<\/p>\n
from Yossi Dukes (privately):<\/p>\n
have to go, but thanks for your talk – much appreciated \ud83d\ude42<\/p>\n
from Giorgio Rovelli to Everyone:<\/p>\n
Thanks Maria, that was great, I think we should post questions selecting Everyone so everyone can see them<\/p>\n","protected":false},"excerpt":{"rendered":"
Slides from the March presentation UsingSQLStoredProceduresFromAccess.\u00a0 A good reference for which Active X reference to use when https:\/\/support.microsoft.com\/en-us\/kb\/231943 remember in general use the oldest common needed reference for your application. A good reference for field type differences SQL to Access https:\/\/www.brentozar.com\/sql-server-access-data-types\/ Our questions from today: from Ben (privately): How do you know what verison of […]<\/p>\n","protected":false},"author":126,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"mc4wp_mailchimp_campaign":[],"footnotes":""},"categories":[1],"tags":[],"yoast_head":"\n
March presentation followup - Lunchtime - AccessUserGroups.org<\/title>\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n\n\n\n\t\n\t\n\t\n