can see data in textpad but cant find it in tables

T

Ted

I don't know access that well to be honest.

I am trying to extract some data from an access 97 database. It
contains 11
tables. I have gone through all the tables looking for the data but?
Can't
seem to find it, well I can find most of it but not all.

If I open the file up in textpad along with a bunch of garbage near
the end
you can clearly find all the data very nicely laid out and easy to
read?

So the data is in there I just can't seem to find what table or field
it is
in?

Any ideas on what step to do next to find this data?

Thanks for any advice in advance

Ted
 
A

Arvin Meyer [MVP]

First: Be careful opening an Access file in a text editor. Accidently saving
it can (and often does) corrupt it beyond repair. Doing so in Word is
guaranteed to make the file corrupt beyond repair.

Make copies of the file before working with it.

Open each table and click inside each field then Press Shift+F2

If none of the fields show data, then your data has been deleted, but the
database hasn't been compacted yet. Your only hope of retrieving it is with
a data recovery service such as Peter Miller http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
T

Ted Cuz

Joseph Meehan wrote:

Also you may have a hidden table.

Menu: Tools - Options - View - Show - Hidden objects.
Click to expand...


Bingo!!

Now I have 8 more tables I never knew about to look in.

I will make a copy of the file before I play around with it so I don't
end up with corrupt data.

Thanks so much very very helpful

Ted
 
T

Ted Cuz

Tables with the MSys prefix are system tables and do not contain user data.
Typically, there are 8 system tables.
Click to expand...

There were 7 system tables and they didn't contain the data I was
looking for.

However going through and hitting shift f2 on each of the fields
turned up were it was.

Now I guess I will move on to figuring out how to extract the data
with PHP.

Thanks
Ted
 
Top