VBA code to reset access mdb file permissions

[mathematician]

Hello.
I have an 2003 access database (mdb file) with all tables having Unknown as owner except one table which has Admin as owner. Is there a way I can use VBA to transfer tables ownership from unknown back to Admin?

 

[xenou]

From what I can find searching around in Google, It sound like if you create a new db and import all your databases objects into it the owner is reset. On the other hand, I'm not sure that there is really any harm in having the tables as Unknown either so it may not really be necessary to do anything.