Problem with database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have an access database sent to me by a user. Either the user has played
around with it or it has become corrupted. Half the tables report that there
is no permissions to read or write them. When I go to Tools-User and Group
Permissions and then click the Owner tab, the tables with the problem report
the owner as unknown. I can't change the owner because I don't have
permission, I can't export or import or repair or recover the data through
any other means. Is there anything I can do?

For background info the database is normally Access97 but the user has
upgraded it to 2000. It uses one single password on the database and no
other security but the user has probably used a utility to crack it. The
database is accessed through a vb6 app so it contains only tables and views.

Many thanks in advance,
Michael


.

Relevant Pages

  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)
  • Re: Active directory corruption
    ... During an installation of PHP I accidentally changed permissions for the ... Active Directory database is unavailable because it is damaged, ... Open a command prompt and run NTDSUTIL to verify the paths for the ...
    (microsoft.public.windows.server.sbs)
  • Re: Active directory corruption
    ... default web site and copied the permissions to all the child ... as it may not be the database that is the problem. ... prompt, use the ESENTUTL to check the integrity of the database. ... To recover the database type the following at the command prompt: ...
    (microsoft.public.windows.server.sbs)
  • Re: security for 100+ user and dbs without having to signin
    ... The owner of a DB can always give themselves permissions. ... by someone unaware of security, then likely they were logged in as ... > database remove all unnecessary permissions from ...
    (microsoft.public.access.security)