Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Sage 100
58 users seats
ver: 5.10.7
I'm getting an error running the following query against ci_item:
SELECT Count(*) as NumRecords from ci_item
There's 90,000 items in the ci_item table.
Works fine on my development system.
Thanks for checking in BL.
Access. Running on Server 2008
Live and Development environment are identical. Server 2008.
Since the Access code works on the development environment, I'm wondering
if I cleared all the users, and restarted the live MAS server if maybe something
may clear, and it might work.
Also, I ran this specific code on the live system about three weeks ago, and it worked.