Several questions and some pain

Hi All,

First question is what to do if somehow security was run on a database I've
designed and yet I have NO idea how or when it was run? There is a
"system1.mdw" file sitting there, and I think it's been there since day one
when I started playing around with Access 2000 back a couple years ago. Any
way to circumvent the security settings? Cancel the settings so they aren't
even there (as, I don't need them anyway...)?

The reason I ask, is that I started using Tony Toew's Auto FE Updater and
was having problems due to "security settings" which was a real surprise.
When starting database on the 2nd machine it was saying I didn't have the
"necessary permissions". Well, heck, if I don't have 'em, nobody does! So,
is there a way around that?

How do I find out what the security settings are? Passwords, etc. I really
am the ONLY one who's been diddling with this thing, so what now? I can't
even blame an employee, unfortunately. All on me.

Is there some way to import all the forms, queries, etc into a new database
and start fresh? The reason I ask that is I've tried to do that (new
database, different name, and File/Get External Data/Import, etc. It copies
everything fine, the forms are there, the queries, etc. But no code. All
the code for each form is empty and inaccessible.

Help!
ron - in a world of hurt!


.

Relevant Pages

  • Re: User has group permissions to object, but still denied access.
    ... permissions to those query objects. ... The owners for the other 68 queries can be changed. ... may have been some of the original queries created in the database. ... Regarding the security, the database was converted from an Access 97 ...
    (microsoft.public.access.security)
  • Re: Access 2003 Macro Security Modification
    ... Hello Mike and thanks for your reply. ... high security settings. ... > kind of setting on the database or change a setting permanently in Access. ...
    (microsoft.public.access.modulesdaovba)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • Re: Setting up user group that can create and save select queries
    ... You are having this problem because of a bug with the security wizard. ... Put your users in one of the wizard-created groups, as well as the group you created for them, and they'll be able to save their queries. ... Give the users modify permissions on the query to change the SQL property in code. ... The application database used to enter and update the data; ...
    (microsoft.public.access.security)