"record deleted" but oh no it isn't - - what's going on?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hullo - I'm using access 2003 working on a database saved to a 'shared files'
folder networked with another computer.

Having created several parameter queries, which worked fine yesterday,
access has decided that it now can't find any records, that they are
"deleted" despite them appearing in the database table.

I suspect this might have something to do with the database being in a
shared folder? - but having 'saved as' the database to my desktop, the same
problem arises. Despite which, a quick try at a new database with parameter
queries worked fine.

Much confusement! - short of interventionalist aliens having a laugh, can
anybody tell me the source of the problem?

Many thanks
 
1. Make double sure that you are in the database which you think you are
especially if the database is split between a Front End and Back End. You
might be linking to a different database BE than you think.

2. Make sure that your parameter queries are working correctly. Try creating
a copy of the query and instead of a parameter, hard code in the criteria.
See if the records show up then.

3. Make sure that your data doesn't have something strange such a leading or
trailing spaces. It may look like the same thing but a single extra space
could make all the difference.

4. When things get strange, try a Compact and Repair.
 
Compact and repair. Excellent.

Jerry Whittle said:
1. Make double sure that you are in the database which you think you are
especially if the database is split between a Front End and Back End. You
might be linking to a different database BE than you think.

2. Make sure that your parameter queries are working correctly. Try creating
a copy of the query and instead of a parameter, hard code in the criteria.
See if the records show up then.

3. Make sure that your data doesn't have something strange such a leading or
trailing spaces. It may look like the same thing but a single extra space
could make all the difference.

4. When things get strange, try a Compact and Repair.
Click to expand...
 
Back
Top