Add ins - LawsonGuru.com - LawsonGuru.com Forums

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3288
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1348
Roger French	1311
mark.cook	1244

Kevin Hagan

Advanced Member

Posts: 30

2/5/2008 2:11 PM

We just got the below response from Lawson regarding a number of our queries which stopped working. Has this issue effected anyone else if so how are you getting around the change. Using related tables in your criteria is no longer allowed. The only exception to this that you can use a single related field, and then it must be the only criterion. So you can use multiple criteria if they are not to related tables.

k-rock

Veteran Member

Posts: 142

2/5/2008 6:17 PM

Stop using Add-ins! A simple Access query is much more powerful. LBI can do queries. Any query tool or BI tool will do it as well.

John Henley

Senior Member

Posts: 3348

2/5/2008 6:31 PM

k-rock, b careful w/ Access queries...as with some databases / query types, they can lock the entire table. Also, if you are using linked-tables and multiple joins, etc. (i.e. not pass-thru queries) you can bring a system to it's knees since Access brings all data over the wire prior to doing the joins. In other words, Access queries (as well as any SQL) needs to be done properly so as to not introduce performance issues......