Is it any way to programmatically store and hide data inside an Access database that it is not shown

[SammyBar]

Hi,

I'm reverse ingeneering an Access database based application program for
integrating it into our enterprises database. I should synchronize the
access database data with our SqlServer 2000 databases in order to allow the
"alien" application work with our enterprise data. I successfully linked the
Access database to SqlServer 2000 and I can read/write to the Access tables.
But it is some data the "alien" application shows that I can not see in the
Access database. I'm convinced the data is actually there because looking at
the binary file (after repairing and compacting) the data is there (the
database is not scrambled). But opening the database in Access 2003 I can
not find the data. None of the shown tables contains it. It is n Access 2000
database that contains only tables and queries. My question is: Is it any
way to programmatically store and hide data inside an Access database that
it is not shown on the Access user interface?

Thanks in advance
Any hint is welcomed
Sammy

 

[Douglas J. Steele]

You can hide tables, either by setting their Hidden attribute, or by
prefixing their name MSys or USys.

Under Tools | Options, check both Hidden Objects and System Objects in the
Show group on the View tab.

 

[Joan Wild]

If I understand you, you have an Access 2000 mdb and a SQL Server database,
and both are used in some application.

When you open the application you see all the data, but when you open the
Access mdb in Access 2003, some data is missing?

Might that data be in the SQL Server database instead?

It's also possible that the mdb has some tables that are hidden. Tools,
Options, View tab and check Hidden objects.

 

[SammyBar]

Under Tools | Options, check both Hidden Objects and System Objects in the

Show group on the View tab.

This uncovered MSys... tables, but no hidden object looks to be present at
the database.
So my data continues missing
Anyway thanks a lot

Sammy

 

[SammyBar]

If I understand you, you have an Access 2000 mdb and a SQL Server

database, and both are used in some application.

No. The "alien" app works only with the Access database. I need to feed the
Access database with our corporate data that is stored in Sql Server 2000.
The "alien" app is a time and attendance and access control system we want
to use to control the access to some doors. The problem is the app comes
with his own database where are registered users, terminals and fingerprint.
Of course we have that information stored in our corporate databases. The
problem is synchronyze both to avoid the need to retype all the info into
the new system and manually maintain in synch both system. It is a simple
project, except for the fact that some data is buried inside the Access
database and I can't figure out how to access them to replicate.

It's also possible that the mdb has some tables that are hidden. Tools,
Options, View tab and check Hidden objects.

I already checked. No hidden objects more than the MSys tables

 

[SammyBar]

Yes, it is.... as a BLOB in a OLE Object field...!
Thanks anyway

Sammy