I’ve got a lot of writing to do today and this weekend. So today’s post will be quick and sweet.
Did you know that you can create your own system tables in Access? That’s right; you can create tables that act like system tables.
Here’s how to do it:
In this example, I’ve got a table called Application_Log. This table holds important variables for my Access application. While the user is in runtime, I update, and log key variables into this table.
I want to hide this important table with the system objects in Access.
All I have to do is prefix my table name with ‘Usys’. This automatically gives the table the status of “System Object”, hiding it instantly.
It looks like the table disappeared, but I can find it by going to Access Options -> Current Database -> Navigation Options, then placing a check next to Show System Objects.
A couple of notes:
- You can also use this trick on Queries, Reports and Forms. That is to say, you can also prefix them with ‘Usys’ to hide them with system objects.
- This also works in Access 2003. You can view system objects in Access 2003 by going to Tools – > Options -> View, then placing a check next to Show System Objects.
RELATED STUFF
