VBA code to reset access mdb file permissions

mathematician

New Member
Joined
Aug 24, 2015
Messages
45
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

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,577
Office Version
2013
Platform
Windows
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.
 

Forum statistics

Threads
1,084,967
Messages
5,380,881
Members
401,704
Latest member
DravenExcel

Some videos you may like

This Week's Hot Topics

Top