Somehow the business unit managed to change a regular table into a system table. Now nobody can read it or edit it. Engine is the owner and nobody has administer permissions. I noticed in MSysObjects that the flag for the table is -2147483648. The only other tables that have that flag are system tables. I feel like I need to change that to 0 and that might solve the problem too.
I tried doing like a GRANT SELECT in VBA but it didn't allow me to do that on the table. Not really sure where to go with this.
Any suggestions? Let me know if you need more details.