Cannot find records

[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!

 

[Philip Herlihy]

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!

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

 

[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.

 

[troy23]

Are you opening a form to look at the data?

If you are going direct to the table and no data is there then it has
probably been removed.

For FREE Access ebook and videos click here
http://access-databases.com/ebook