The Way We Word: Record-Level Access Revisited!

[Absolutely_Nobody]

** This thread discusses the article: The Way We Word: Record-Level Access Revisited! (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3624) **
I am getting an error CWBZZ5008 Security error occured when attemting to connect to system MYAS400. I have set breakpoints and stepped thru the code. This is occuring on the rs.Open. I have a QZDASOINIT job so I can see that I have a connection. I have MDAC 2.5 and Client Access V5R1M0 is at the current service pack. <hr width=50 align=left>Code ('http://www.mcpressonline.com/mc/showcode@@.6ae8460a/0')

[Absolutely_Nobody]

** This thread discusses the article: The Way We Word: Record-Level Access Revisited! (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3624) **
I used the code below and got data with no problem. Why can't I use RLA ? What are the concerns with SQL vs. RLA ? If I use SQL does it affect the network by bringing over blocks of records that I don't need since I know which records by key that I am looking for ? <hr width=50 align=left>Code ('http://www.mcpressonline.com/mc/showcode@@.6ae8460a/1')

[MCWebsite.Staff]

** This thread discusses the article: The Way We Word: Record-Level Access Revisited! (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3624) **
** This thread discusses the Content article: The Way We Word: Record-Level Access Revisited! (http://www.mcpressonline.com/index.php?option=com_content&view=article&id=3624) **
0