We are using an Access Database that was written several years ago. The person who originally wrote the database is no longer here. It has been updated to the latest db version over the years as/when necessary.
Over the weekend, the db increased in size from 11 Meg to 233 Meg. It was brought to my attention the users were having issues this morning, and that is when I discovered the increase in size.. I compacted and repaired, and size dropped from 233 meg to 11.5 meg.
But when we run the query referenced in the sql view below, we will intermittently receive an error message "Property Value too Large".
on top of the error message, the first column in the query is dropped. We copy the crosstab out of the db and into an Excel spreadsheet using vlookups to summarize data for analysis. dropping a column causes the vlookup to not work.
Also, we are having problems with permissions, which only occurred intermittently in the past.
any help would be appreciated!
TRANSFORM Sum(IncomingRawGlass.PalletQuantity) AS SumOfPalletQuantity
SELECT IncomingRawGlass.ItemNumber, GlassDetails.Comment, IncomingRawGlass.DeleteRowsNotEntireSheet, IncomingRawGlass.DeleteRowsNotEntireSheet
FROM (dates2 INNER JOIN IncomingRawGlass ON dates2.dates = IncomingRawGlass.DateDue) INNER JOIN GlassDetails ON IncomingRawGlass.ItemNumber = GlassDetails.[Item#]
WHERE (((IncomingRawGlass.DateDue)<Date()+"45"))
GROUP BY IncomingRawGlass.DeleteRowsNotEntireSheet, IncomingRawGlass.ItemNumber, GlassDetails.Comment, IncomingRawGlass.DeleteRowsNotEntireSheet
PIVOT IncomingRawGlass.DateDue;