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

30 Nov 2006 2:32 PM

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

30 Nov 2006 2:41 PM

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Show quoteHide quote

"SammyBar" <sammy***@gmail.com> wrote in message
news:%23dQXYxIFHHA.964@TK2MSFTNGP05.phx.gbl...
> 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
>

30 Nov 2006 3:13 PM

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

30 Nov 2006 2:58 PM

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.

--
Joan Wild
Microsoft Access MVP

SammyBar wrote:

Show quoteHide quote

> 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

30 Nov 2006 3:24 PM

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

30 Nov 2006 7:03 PM

SammyBar

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

Sammy