PC Review


Reply
Thread Tools Rate Thread

Changing database ownership

 
 
Ron's Access
Guest
Posts: n/a
 
      16th Oct 2009
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.
 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      17th Oct 2009
The MDW files carry the credentials of each user. By deleting them, you
cannot regain either ownership status, or admin status, unless you have the
exact PIDs and usernames of each member. The actual permissions are carried
within each database, but they refer to the MDW file for credential
authentication.

I hope that you have an exact rebuild, or didn't actually delete the MDW
files because if you did, you'll need to find someone who can crack
security. If there was personal data in those tables, whomever you find,
better be bonded and have certificates, or you may have a bigger problem
with various governments.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Ron's Access" <Ron's (E-Mail Removed)> wrote in message
news:BDDD6FE8-1111-4B5E-B34B-(E-Mail Removed)...
> 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.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing File Ownership romeboy Windows Vista General Discussion 3 4th May 2008 08:22 AM
changing ownership from one user to another? Mike Windows XP Security 0 26th Sep 2007 04:18 PM
Changing the Ownership of Database object Roshan Abbasi via AccessMonster.com Microsoft Access Forms 4 14th Jul 2005 10:19 PM
Changing Ownership =?Utf-8?B?RGF2aWQ=?= Windows XP Configuration 2 9th May 2005 07:15 AM
changing ownership RipperT Microsoft Access Security 1 4th Apr 2005 12:45 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:22 PM.