Login password

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

Guest

How can I create a login when opening a database?
What I need is an acount that allows to edit the design (full access) and a
user login that only allows adding data.
I have tried the security functions in Access but I dont get it right. When
using this the user (that is set to only add records) is still able to edit
the design of the database.
 
=?Utf-8?B?UG91bCBFcmlrIEphY29ic2Vu?=
How can I create a login when opening a database?
What I need is an acount that allows to edit the design (full access)
and a user login that only allows adding data.
I have tried the security functions in Access but I dont get it right.
When using this the user (that is set to only add records) is still
able to edit the design of the database.
Click to expand...

If you want to use the built-in Access user-level security then you first
need to read and understand the MS KN article:

<http://support.microsoft.com/default.aspx?scid=/support/access/content/sec
faq.asp>

Then, and only then, make *copies* of your files and work on them (it's
very easy to lock yourself out). There's also a step-by-step guide on my
website that may help.

Regards,
Keith.
www.keithwilby.com
 
You could just remove all Microsoft Access built-in toolbars and hide the database window from certain users during startup; thus limiting these users to the GUI (Graphical User Interface).

Otherwise, for other users, you can keep the toolbars active.

If you have Microsoft Access 2000, I have an example file that illustrates the toolbar removal and a couple other details, like idle detection. Here's a link:

http://sthosting.zapto.org/Technology/Downloads/IdleDetect.zip

Note: The file is zipped; thus, you will need a compression utility program (like WinZip) to unzip the file.

Best regards,

Todd
How can I create a login when opening a database?
What I need is an acount that allows to edit the design (full access) and a
user login that only allows adding data.
I have tried the security functions in Access but I dont get it right. When
using this the user (that is set to only add records) is still able to edit
the design of the database.
 
Back
Top