Hello, we have appeared to run into a limitation of access. When we have more then 40 rows in a table, it gives us a "too complex of a query" error. If this is a limitation we can overcome, we would like to know. Otherwise, we are planning on switching over to SQL 7.0 in a while, is there a limitation on sql's amount of row's like access appears to have. Thank you.