Changing database ownership

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

After my old system crashed I restored my Access database to my new system.

In security it says that the database and many of the objects (primarily
tables) have the owner <unknown> and I can not open these tables.

I have deleted the mdw files, created new ones, created a new database and
tried importing these tables but I keep the message that I don't have
permission to access them.

If anyone can please help I would be greatly appreciated. These tables are
quite complicated and it would be almost impossible to recreate them from
scratch.

I have tried running the database on both an XP system and a Vista system
and get the same problem.
.

Relevant Pages

  • Re: Log In
    ... R_W - read and write permission but cannot delete or modfiy existing reocrds ... knowledge about security for database. ... accomplishing it? ...
    (microsoft.public.access.security)
  • Re: Dont need security in Access 2007 or Access 2003
    ... Go to Tools, security, ... Grant full permission to every object (including the Database object) to ... This new database is your unsecured mdb. ...
    (microsoft.public.access.security)
  • Re: How do I bind username password security to a specific databas
    ... I now have the database properly secured. ... the security FAQ document. ... I am still wondering why my other access database ... still tied to the entire app rather than the database file. ...
    (microsoft.public.access.security)
  • Re: Any way to prevent conversion?
    ... Go to the Security menu, select the default user, ... remove permission for open exclusive. ... (You have to scroll ... UP from 'tables' to see the permissions for the 'database' ...
    (microsoft.public.access.conversion)
  • Concurrency Violation in DataSet Update ADO.NET
    ... Now I am developing Cheque Writing ... 'UPDATE DATABASE ... "TBKKTC") ... I use password to protect my Access database from ...
    (microsoft.public.dotnet.general)