I was using the security wizard and quickly grasped I didn't know what I was doing, so like someone with common sense, I decided to stop what I was doing and cancel the wizard. Everything seemed fine, or so it would have seemed.
I then began to finish the database after a few days I closed it and saved. When I reopened the database to test it out, the wizard has somehow removed all rights for both users and Admin. I won't pretend to know how, but it has.
now I cannot even view my own tables and modules because I don't have access. I cannot create a new user with rights because all new users just have the same 0 rights.
is there anyway I can reinstate the admin to have full rights?
Is there a way I can export the tables I need into the back up without rights? I can rewrite the VBA quickly enough but the data in the tables is about 4 days work.
Really in a pickle here, the backup is pre-security wizard so has none of the data in it