From the course: Access 2016: Advanced Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Access the system tables
From the course: Access 2016: Advanced Tips and Tricks
Access the system tables
- [Voiceover] Access keeps track of everything that happens in your database through a collection of hidden system tables. Usually these are kept far out of reach, but it's interesting to know that they exist and see how things work under the hood. Before we do, however, a word of caution. Messing about with the system tables can be dangerous. And at no point should you attempt to modify anything in them. If any changes are made to a system table it can corrupt the entire database. Now with that said, we can reveal the system tables by right clicking in the navigation pane over here and choosing Navigation Options and then turning on these two check boxes. Show Hidden Objects and Show System Objects. When I say OK, you'll notice that our navigation pane grows and we see lots of new hidden system tables that all start with the prefix MSys. We can work with these hidden system tables just like any other table of the database by double clicking on it to see the information. Let's double…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.