Table owner: Engine

Posted on 1999-07-07
Medium Priority
Last Modified: 2012-08-14
I was opening a brand new mdb, and it comes up with existing tables that I didn't put in because its new. I try to delete them but it won't let me,  the tables are dimmed out and the owner is down as being the Engine in the tables' properties.
Question by:tyy8
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Accepted Solution

fontmaster earned 120 total points
ID: 1999129
You are probably seeing system tables, particularly if their names begin with the characters "MSys"!

Somehow, a recent user of your Access system has set them to be visible.  To make them disappear:

Pull down the Tools menu and click on Options...
Select the View tab and if you see that "System Objects" has been selected, then this was indeed your problem.  Just uncheck it.


Expert Comment

ID: 1999130
Oh, and by the way, click the "Apply" button at the bottom of the form before exiting!

Author Comment

ID: 1999131
That was it - but what are those darn things for??

Expert Comment

ID: 1999132
These are the tables where Access keeps track of your table structures, queries, preferences, etc.  All the internal information that gets displayed for you when you look at the objects you have created.

It's all saved within your own database so it can't get separated like it does in the earlier X-base type databases.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question