"Record is deleted" error with query

[dgreene]

I'm pretty new to Access and am trying to help build a simple database for some of our employees to use. Today, I've been working on creating a Query to let them pull records related to a particular location.

The problem that I am having is every time I test the query it shows the data I want, but after a few seconds a "Record is deleted" box pops up. When I click OK, everything in every cell returned from the query shows "#Name?" instead of the data it showed seconds earlier.

Does anyone know what is going on here and how do I fix this? I'm assuming there is something stupidly simple that I am not aware of.

 

[Cerial]

I'd look into why the record is getting deleted. I'll presume your query is based on Access tables (not linked tables nor other Access queries). If it isn't, that might explain why your records are disappearing. Or you might have a user on the same database as you that is deleting the records that you are trying to use -- this would be like both of you trying to write on the same piece of paper, and the other person snatches the paper away before you can do what you need to do.

There's just so many ways this can go, so maybe if you provided more info, it might help narrow the field. Good luck!

 

[dgreene]

It is a very simple split database with employees entering information on a front end and the actual data table sitting in a back end file on a shared folder. I was trying to work on some queries over the data table to make it easier for them to pull records related to a particular location and time frame.

 

[Cerial]

Two possibilities?
1) I'm trying to recall, but if your SELECT query is joining multiple tables, but you still want your users to be able to modify the data, that Access can't figure out how to save certain fields in one table and other fields in another. Kinda depends on what your query looks like.
2) The filters you're applying may no longer apply when your users touch the data, causing the record to disappear?

Sorry that's not a major assist, but maybe specifics would again help.