Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Unknown owner of tables

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
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: …
Suggested Courses

886 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