Remove User Level Security from my front end

  • Thread starter Thread starter Jordan
  • Start date Start date
J

Jordan

I created a front end and only had a few users in the Admin group able to
modify the front end. Now that I am not working with anyone on this I want
to do what I wanted and put the back end on SQL and just make the front end
an MDE file so no one will mess with the code.

I have heard a lot of problems with removing users level security from the
front end such as loosing code or code not linking up right. What is the
easiest way to get this a front end that has forms, reports, queries, and
modules with set permissions on them back to the defaults.

The file was originally created in and is currently saved in Access 2000
format. I am using Access XP to edit it.
 
Jordan said:
I created a front end and only had a few users in the Admin group
able to modify the front end. Now that I am not working with anyone
on this I want to do what I wanted and put the back end on SQL and
just make the front end an MDE file so no one will mess with the code.

I have heard a lot of problems with removing users level security
from the front end such as loosing code or code not linking up right.
What is the easiest way to get this a front end that has forms,
reports, queries, and modules with set permissions on them back to
the defaults.

The file was originally created in and is currently saved in Access
2000 format. I am using Access XP to edit it.
Click to expand...

I have never heard of any such problems upon removing security. Just open
it as an administrotor and give full permissions to the group "Users". Then
close Access and reopen using the default System.MDW file, create a new
blank file, and import into it all of the objects from your current file.
The resulting new file will be identical to what your current file would
have been had security never been applied.
 
Jordan said:
What is the easiest way to get this a front end that has forms, reports,
queries, and modules with set permissions on them back to the defaults.

The file was originally created in and is currently saved in Access 2000
format. I am using Access XP to edit it.
Click to expand...


Open the frontend logging in as a member of the Admins Group. Grant full
permissions on all objects to the Users Group. Check in Tools, Security,
Workgroup Administrator that you are joined by default to the system.mdw
workgroup file that ships with Access - join it if necessary.

Close Access (important step!). Reopen it and create a new mdb (you should
get no login prompt). File, Get External Data, Import and navigate to your
secure mdb. Select all the objects, and click on Options and ensure you
import any toolbars, import specs, etc.

That's it; you are now looking at an unsecured mdb. Repeat on the backend,
if it is secured.

Remember, that if you are going to make a MDE file, that you keep the MDB in
case you need to make design changes.
 
The only way that someone might "lose code" after desecuring a
database, is if they had an MDE database, and expected to see
sourcecode in it, when the security had been removed.

MDE database do not have any sourcecode - secured or otherwise.

HTH,
TC
 
Back
Top