Access 2013 regularly "loses" a query definition

homer911 · 2016-06-17 21:27:05

I am developing an application which ultimately will be used to query a SQL Server DB (no writes/updates). In the meantime I am running it against a very modest quantity of test data within the database. Access is regularly dropping one of my queries, just leaving me with "SELECT ;" While I can restore this from a backup,…

17-06-2016 09:27PM

#1

homer911

Registered Users, Registered Users 2 Posts: 5,069 ✭✭✭

Join Date: September 2007

Posts: 4684

I am developing an application which ultimately will be used to query a SQL Server DB (no writes/updates). In the meantime I am running it against a very modest quantity of test data within the database. Access is regularly dropping one of my queries, just leaving me with "SELECT ;" While I can restore this from a backup, I'd love to be able to prevent it for the production version. The code is MS Access style syntax and uses a number of iif statements. I'd consider changing this to a pass-through query in production if it fixed the problem - any suggestions? Cant find anything through Google..

0