Hide system tables in mdb created with CreateDatabase method

[Dale Fye]

I have an application which allows the user to create a new database, then
links or imports data from an Oracle database into the MDB.

After using the Createdatabase method to create the mdb, I want to be able
to hide the system tables. Any ideas?

 

[Rick Brandt]

I have an application which allows the user to create a new database,
then links or imports data from an Oracle database into the MDB.

After using the Createdatabase method to create the mdb, I want to be
able to hide the system tables. Any ideas?

System tables are automatically hidden. If the user has "Show Sytem Objects"
enabled then there is nothing else you can do AFAIK.

 

[Dale Fye]

Rick,

I thought "ShowSystemObjects" was specific to the database, not an Access
wide setting. I should have thought of that, since I have it enabled on my
machine, and that is where I was testing the code in question.

Is there no way to set ShowSystemObjects to False through code?

Dale