Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Unknown owner of tables

Posted on 2001-06-13
5
Medium Priority
?
589 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 400 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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 different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

705 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