Solved

Unknown owner of tables

Posted on 2001-06-13
5
585 Views
Last Modified: 2008-02-01
We have a 400Mb Access 97 database. It needs repairing every few days, using a PC with MDAC 2.5

This morning on opening the database we could not read some tables.

In "User Groups and Permissions" dialog it shows "Current Owner" as "<Unknown>" instead of "Admin" for those tables.

0
Comment
Question by:manno
  • 3
  • 2
5 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 100 total points
ID: 6185982
Your MDB container is corrupt.  Create a fresh MDB and import everything into it. See the following MSKB article:

http://support.microsoft.com/support/kb/articles/Q236/8/88.ASP

If that's not possible, then you need to try and repair it (after making a backup) with JETCOMP.EXE.

  This is a standalone repair/compact utility.  It's available on Microsoft's web site.

Jim.

0
 
LVL 57
ID: 6185993
Also, you need to investigate the reason that a repair is required so often.  That is not normal.  This can be done with LDBVIEW.EXE.

  LDBVIEW is a utility that allows you to determine what station caused the MDB to be put in a suspect state thus forcing the repair.

Let me know if you want more info on this.
Jim.
0
 
LVL 1

Author Comment

by:manno
ID: 6186119
Thanks, Jim

I found the article you quote myself but this doesn't exactly match the problem.

Good info about Jetutils.exe; I've downloaded this.

I will wait a day before awarding points,

Manno
0
 
LVL 57
ID: 6186151
Manno,

 While the article doesn't match the problem exactly, if you read down a bit, you'll see that the it does describe the problem your having and what can cause it.

  I included the article link as it explained how to change the owner back to admin.

Jim.
0
 
LVL 1

Author Comment

by:manno
ID: 6186239
On reflection I agree.

Thanks Jim
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

860 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