sign-in page
f
i need to create a form in Access 2000, where the User
has to enter in a correct username and password in order
to gain access to other forms in the database.
I have a table called users. And in it, i've created the
following fields: userid, username, password
can anyone tell me where i may find code to create a form?
thx in advance.
John Nurick
an effective approach, because any experienced user will be able to
retrieve the data - even the username and password data - direct from
the tables. For effective control over who can use which forms or access
what data, you need to implement Access user-level security. This is not
simple: you need to read and understand the Security FAQ first, make a
backup of the database, and follow the instructions very carefully.
Security FAQ - includes explanations and step by step instructions
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793
or
http://support.microsoft.com/support/access/content/secfaq.asp
Security Whitepaper (written for Access 2.0, but explains the concepts)
http://support.microsoft.com/default.aspx?scid=kb;[LN];122036
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
Joan Wild
"John Nurick" <j.mapSo...@dial.pipex.com> wrote in message
news:iqoiev4i6vssqm8vk...@4ax.com...
> Security Whitepaper (written for Access 2.0, but explains the concepts)
> http://support.microsoft.com/default.aspx?scid=kb;[LN];122036
A more recent whitepaper (still out of date though)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q148555
--
Joan Wild
Microsoft Access MVP
John Nurick
wrote:
>A more recent whitepaper (still out of date though)
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q148555
Thank you.
