Data types are not optional, and provide the most basic type of data validation.
For more information about data types, field sizes, and input masks, see the article Introduction to data types and field properties.
What if i have 2 tables in my ms access db namely accdb and adminaccdb.
I have a MS Access database application that currently has a table with user names and passwords which is checked against when a user is logging into the app.
Instead of requiring users to remember this application password, I would like for them to be able to just enter their current Windows password.
You can only prevent any unauthorized person running the Access application on other person's computers." id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5459053" / You may not be able to retrieve Windows login password.
If any application program can easily access login password it can make the system very unsafe. You Access database is not really protected if you are using Windows login account and password.
A validation rule is one way to restrict input in a table field or a control (such as a text box) on a form.
Validation text lets you provide a message to help users who input data that is not valid.You can define validation rules for table fields and for controls on forms.When you define rules for tables, those rules apply when you import data.To add validation rules to a table, you open the table and use commands on the Fields tab of the ribbon.This Access tutorial demonstrates how to create user login Form, verify password, create user level / privilege You may also want to read: Access Form mask Password Text Box Auto Run Access Form using Auto Exec There are many tutorials in Google about making user login Form, some of them make a lot of error handling and conditions.The below code will prompt user a Msg Box if either password or login ID is Null.