can see data in textpad but cant find it in tables

[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

 

[Joseph Meehan]

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

I suspect you are seeing deleted data. Access does not really delete
data until a compact is run.

 

[Joseph Meehan]

Joseph Meehan wrote:

Also you may have a hidden table.

Menu: Tools - Options - View - Show - Hidden objects.

 

[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

 

[Ted Cuz]

Joseph Meehan wrote:

Also you may have a hidden table.

Menu: Tools - Options - View - Show - Hidden objects.

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

 

[Arvin Meyer [MVP]]

Tables with the MSys prefix are system tables and do not contain user data.
Typically, there are 8 system tables.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Ted Cuz]

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

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

 

[Arvin Meyer [MVP]]

Should be easy enough, using VBA, to create a text file which can be read by
anything. Look at the TransferText method in the help files.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access