Hi,

I have a problem concerning the admin user privileges of my Microsoft Access database. I have developed an Access database that offers a graphical user interface to the end users. These end users need to log in to the database application, so I have created a workgroup file, some users and passwords and for each user I have set more or less database privileges (some users may only read data, whereas others may also insert new records etc.).

However, I have also accidentally removed general database operation privileges from the the default admin account and now I cannot access the database to edit tables, forms, relations etc. anymore. In other words: as the admin user I can now only log in as the highest privileged end user (read an write data through the GUI).

:eek:

This is a serious problem, because the database application is not finished, yet. And since it will be a hell of a job to recreate the whole database application from scratch, I was wondering whether there are tools available that can 'crack' the security / privileges settings of users and set them to their defaults, so that I can have full database access (editing schemas, relations, forms etc.) again as the admin user.

Thanks in advance and kind regards!