Well hello again!
My IT guy and myself (neither an Access guru) are stumped with an simple action that ends up crashing Access.
Below is a screenshot of how I have the Query connected.
A little background:
- The tables are externally linked through and OBDC connection to an AS400/IBMi server
- Each table is linked through the OrderNumber (except IESFILE_CUSTMAST which is through customer code and just brings in the customers full name)
At this point I can run the query without issue and it pulls in all the data I need. However I have tried to do a few simple things that end up crashing the Access (AKA it becomes non responsive)
1. When I put a criteria on the date field (second column) the Access will become non responsive and crash. I tried doing >1/1/16 and >#1/1/16# and both just crash Access.
2. When I create a second query (which summarizes miles drive by OrderNumber) and link it to the Test 3 query then run the query it will crash Access.
Any ideas why my Access is crashing whenever I try to add criteria or link another query to it?
Thanks Everyone~!
Jon