I have a Access application that is connecting the SQL Server Express
They use this application every day, through the day. Where I, as the developer, have a copy of the database from March 2014.
Now, when the client is trying to generate a report, which they do on a weekly basis, the following error comes up:
Run-time error '3464':
Data type mismatch in criteria expression
For this application, all queries are in the UI. I am not using stored procedures, triggers, etc., all I am storing within SQL server is my tables.
The report uses a date range, so given that I have a March copy of the database, I am using January 1 to 31, 2014 for my criteria. So, I did a count of the number of records within this date range, and my database copy returned 512 records. I backed up my version of the database, and restored a fresh version in my environment - the record count is also 512, so I am working relatively with the same data.
However, if I run the report for January 1 to 31 against my March database, I get no errors, but when I ran the same Jan 1-31 against today's database, I get the above error. This is on my environment, so code changes are not possible by third party. Database changes are, but highly doubtful.
Even last week's report range, which worked, no longer does.
What could it be? My only suspicion that I am using Express, which I know the database limit is 1 GB, but under database property I see that the size is 90.50 MB, but space available is 0.91MB
... Could that be something?
Also, it maybe unrelated, but what is number of users under the same page?
Any ideas would be appreciated.