Cannot find records

N

Nikki

I only use access once a year for a benefit we hold. I have a file that is
2,692 KB. But when I open it, there is not data in Tables. I have no
filters on. I know the data is there, where is it? I had this problem last
year and forgot to make notes!
 
L

Linq Adams via AccessMonster.com

If "there is not data in Tables" then your statement "I know the data is
there" is patently false!

If what you mean is no data shows when you open a ***form*** it could be a
number of things.

The form's Data Entry Property could be set to "Yes" in which case you can
only enter new records but not view existing records.

Does the form have a Record Source set; i.e.is it actually bound to a table
or query?

When you move to the Tables tab of the Objects dialog box, are the names of
any tables visible? What happens if you click on one of the table names?

Can't really do much more guessing on the info you've supplied so far.
 
P

Philip Herlihy

Nikki said:
I only use access once a year for a benefit we hold. I have a file that is
2,692 KB. But when I open it, there is not data in Tables. I have no
filters on. I know the data is there, where is it? I had this problem last
year and forgot to make notes!
Click to expand...

Could the "real" tables be in another file? Try Tools > Database
Utilities > Linked Table Manager, and see if there are any clues there.

Phil, London
 
D

DJH6064

Try clicking on the file menu, and then select "database properties" and
click to open the Properties dialog box. Then click the "contents" tab to see
a list of any tables, querries, forms etc.. If any tables show up, then go to
the tools menu and select "Options". On the View tab, make sure the "Hidden
objects" checkbox is checked, then click ok. Let us know what you find out.
 
Top