Hide system tables in mdb created with CreateDatabase method

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale Fye - 22 Nov 2005 17:11 GMT

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?

Reply to this Message

Rick Brandt - 22 Nov 2005 20:23 GMT

> 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.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

Dale Fye - 22 Nov 2005 22:13 GMT

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

>> 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.
[quoted text clipped - 4 lines]
> System tables are automatically hidden. If the user has "Show Sytem
> Objects" enabled then there is nothing else you can do AFAIK.

Reply to this Message