Solved

Unknown owner of tables

Posted on 2001-06-13
5
581 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

747 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now