prevent structure changes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I'm using access2003 and I would like to know if it's possible that the
user of the database have access only to forms and reports, avoiding to
change the structure of the database...

Sorry if it's not well written :S

I'm Portuguese :S

:D :D
 
Hi,
there are many different options.
You could create an .mde file of your mdb version (tools--database
utilities--convert database...) which will prevent any design changes, but
this also means it will prevent you from doing design changes. You would need
to keep a copy of the original mdb, make new changes to it and recreate a new
mde to replace the old one.
Other methods are to hide the database window and disable all build in menus
and shortcut keys (tools--startup...). The only way to get back into the db
is to hold down the shift key on startup. If you think your users are
computer literate enough you can also disable shift key, but there are
methods to re-enable it, too.
In the end you can put as many walls as you want into someones way, if they
know what they are doing they most likely will surpass them.
HTH
Good luck
 
User level security will allow you to deny permissions to some object
(eg tables) while allowing the user to change other objects (eg,
forms).

Access user security is not to be taken lightly, so read very
carefully and thoroughly, practice on a COPY of your database, and
don't skip any steps in the process.

Here are a number of links about security:

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Security

If you haven't done so already, split your database into a frontend
component (forms, queries, reports, etc) and a backend component
(tables only). The backend belongs on a shared folder on your network
server, while each workstation should have its own copy of the
frontend.

http://www.granite.ab.ca/access/splitapp/index.htm

Once you have split the database, you will want a method to
automatically distribute any modifications to the various
workstations. Many people use:

http://www.granite.ab.ca/access/autofe.htm

Hi, I'm using access2003 and I would like to know if it's possible that the
user of the database have access only to forms and reports, avoiding to
change the structure of the database...

Sorry if it's not well written :S

I'm Portuguese :S

:D :D
Click to expand...
**********************[email protected]
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Back
Top