This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have several queries I use in Access, and random ones will delete the SQL statements and only have "Select;". I have no idea what could be causing this as it is not the same query each time that gets deleted. Additionally, this happens at odd times. I will have exported the query to Excel and then go back to the query a few minutes later to see that it's now gone. We do have this database stored in a shared location and use a Macro to pull data in. We mostly noticed the disappearing after we pull data in, but sometimes this happens when we are only exporting queries. We have been in luck that one of us had the database on our desktop, which contained the query that got deleted. We don't want to risk losing any, however, as they took a lot of effort to create. Please advise how we can prevent this from happening in the future, thank you!
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Not that I have seen this happen but I'm thinking that it might be because the database is not split with Frontends on everyone's local. Is that the case?