Re: Problem with database

The user probably played around a bit. Perhaps running the security wizard.

Get them to send you the secure mdw file that they used.


--
Joan Wild
Microsoft Access MVP

Michael C wrote:
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: You do not have the necessary permissions to use the object. Have your sy
    ... security wizard went to work on it. ... You need the secure workgroup file to open your secure db. ... middle i have installed access 2003 and continue working with my database. ... message appears You do not have the necessary permissions to use the ...
    (microsoft.public.access.security)
  • 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)
  • Re: Viewing object owner in SQL 2005 - ownership chaining
    ... The server principal "HFDB_2_0_readonly" is not able to access the database "Hotfix_data" under the current security context. ... To add on to Erland's response, the user needs a security context in both databases, even if no permissions are granted. ... I'm trying to set up Ownership Chaining. ... When I set up both a table and view from one logon and granted permissions to the view it didn't work, evidently because "creating user" is not equivalent to OWNER. ...
    (microsoft.public.sqlserver.security)
  • RE: Access 97 Security issue Cant make a MDE
    ... "If the database is secured using user-level security, ... logged in as the owner of the database, or at least a member of the Admins ... > the dayabase as a user AND can sign in simply as admin, ... > that the user account has Modify Design or Administer permissions for the ...
    (microsoft.public.access.security)
  • Re: permissions to import after a new workgroup file?
    ... To import as a new owner from a previous owner, ... for the objects in the original database. ... Normally permissions are assigned via Groups. ... You shouldn't be altering security measures with the "default workgroup". ...
    (microsoft.public.access.security)