Solved

Unknown owner of tables

Posted on 2001-06-13
5
587 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
[X]
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
  • 2
5 Comments
 
LVL 58

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 58
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 58
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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