P
Paul (ESI)
(I accidentally posted this question in the wrong Access forum and I don't
think there is any way of editing my message once I post it. I wasn't able to
move it to the correct forum, so I'm just re-posting it here where it really
belongs.)
Luckily, I don't actually have to do this, but I would like to know how to do
so in case myself or a colleague may have to in the future. I created a test
database and set up user-level security. I messed something up, and I could
no longer edit my database at all. I could no longer even change permissions
in order to regain control of my database. I must have accidentally not given
anybody the permission to edit anything. Not really sure what I did,
actually, but I messed something up (it was my first time setting up
user-level security).
How are you able to get your database back to a normal, unsecured database.
I know you supposedly should be able to do this using the .bak file, but I
just could not figure it out. I'm sure you shouldn't have to do so the way I
did. What I did was I opened the .bak file in Access and copied all of the
tables, forms, reports, etc. into a new database. I deleted the secured
database and the .bak file and I had my database back the hard way.
I am sure there must be an easy way to do this. Imagine if I had a database
with a bunch of tables, hundreds of forms, tons of reports, and so on. It
would be a pain in the rear end to have to copy and paste all of that to a
new database. For future reference, I'd like to know if there is a faster,
easier way, and how to do it if there is. Any help would be greatly
appreciated.
--
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy
think there is any way of editing my message once I post it. I wasn't able to
move it to the correct forum, so I'm just re-posting it here where it really
belongs.)
Luckily, I don't actually have to do this, but I would like to know how to do
so in case myself or a colleague may have to in the future. I created a test
database and set up user-level security. I messed something up, and I could
no longer edit my database at all. I could no longer even change permissions
in order to regain control of my database. I must have accidentally not given
anybody the permission to edit anything. Not really sure what I did,
actually, but I messed something up (it was my first time setting up
user-level security).
How are you able to get your database back to a normal, unsecured database.
I know you supposedly should be able to do this using the .bak file, but I
just could not figure it out. I'm sure you shouldn't have to do so the way I
did. What I did was I opened the .bak file in Access and copied all of the
tables, forms, reports, etc. into a new database. I deleted the secured
database and the .bak file and I had my database back the hard way.
I am sure there must be an easy way to do this. Imagine if I had a database
with a bunch of tables, hundreds of forms, tons of reports, and so on. It
would be a pain in the rear end to have to copy and paste all of that to a
new database. For future reference, I'd like to know if there is a faster,
easier way, and how to do it if there is. Any help would be greatly
appreciated.
--
Have a nice day!
~Paul
Express Scripts,
Charting the future of pharmacy