Hiden

S

Sylvie

Hi

I use a program that open an access database and show it to the user.
But when I open this database with access, some informations that
are shown by the program are not present in any table of this database.

How is it possible ?


Sylvie
 
J

James Hahn

1. The data is hard-coded within the program
2. The program calculates the data, based on the information in the database
3. The program gets the data from some other file, or somewhere else within
the system.
 
S

Sylvie

James Hahn said:
1. The data is hard-coded within the program
Click to expand...

No, data are updated each day and the program doesn't change.
2. The program calculates the data, based on the information in the
Click to expand...
database

Ok. But I really don't know where these data are !
3. The program gets the data from some other file, or somewhere else
Click to expand...
within

There is no other files
 
J

James Hahn

Just because the data changes doesn't mean it isn't hard-coded in the
program. There might be a lookup table contained in the program that
returns different results depending on the data in the database.

Other information that the program could be using doesn't have to be a file.
It could be in the registry, it could be based on the date, it could be
downloaded from the www or it could be randomly generated (like a password).
 
T

Tom Wickerath

Hi Sylvie,

Click on Tools > Options..., select the View tab, and place checks in the Hidden objects and
System objects. Click on OK to dismiss this dialog. Don't touch any of the system tables that
start with Msys. Do you see any new tables that may have been previously hidden? Do you see any
tables with the Usys prefix?

Tom

_____________________________________


Hi

I use a program that open an access database and show it to the user.
But when I open this database with access, some informations that
are shown by the program are not present in any table of this database.

How is it possible ?


Sylvie
 
S

Sylvie

It is a Horse races data program. Each day the user can
connect to a server on web and update its race database
by downloading the result of the yesterday race and the
data of the tomorrow race.

Opening the database with Access, you can see that
everything is in Ascii, not coded. Horse name, race
date, Horse Odds, etc. everything is in clear text.

Each time the only data that are missing are the tomorrow race one.
Using access you can't see these data in the database but the
prog can see them. An other idea is that they written somewhere
in the registry. I'll try to see if it is the case.

But I think that these data are coded in the database. I thinck
that some data are scrambled and melt and that the
next day data are included in. The prog knows how
to déscramble the data. But it must use a spécial request to
access the scrambled data and I wonder if one can intercept
SQL request that a prog use ?

In other word, is it possible, under windows XP to hoock/monitore
SQL request that are use by a program to extract data
from a database ?


Sylvie
 
T

Tom Wickerath

Hi Sylvie,

You wrote to James:

"Each time the only data that are missing are the
tomorrow race one. Using access you can't see
these data in the database but the prog can see them."

Is this missing data available to your application if you do not have an internet connection? I
suspect that it is using a connection to retrieve information about an upcoming race, such as the
track, names of the horses, odds, etc. If you pull the plug on your connection, is this data
still available? If not, then this is consistent with James' third suggestion in the 2nd
paragraph of his 2nd reply, ie: "it could be downloaded from the www".

Can you provide examples of the type of information that you are seeing displayed in a form or
report, which you cannot find in any tables?


Tom
________________________________________________


No. There is no Usys* tables.

Sylvie
 
J

James Hahn

You won't find anyone here willing to help you hack into data that someone
has deliberately tried to conceal. Sorry.
 
Top