Microsoft Access
HELP

Sources for Quick Answers

Microsoft Access
Microsoft Access site

Google
Advanced

Questions from Users

Topic

Question & Answer

Data >How can I add a record simultaneously and automatically to two tables in a One to One Relationship?  I have enforced referential integrity, so it can cascade update and cascade delete automatically, but not add.

Relationships between tables only apply to existing records.  There is not "cascade add" for records.  You will have to put in some code.  Here is an example of how it can work.

Data >My Zip Codes have only 3 or 4 digits to them, especially in Connecticut and Massachusetts

During the data conversion, the Zip Code field was probably set to Numeric instead of Text
Here is how you can convert numeric to text and fix the zip codes

Locking > Only one person can get in to the file, and not two or more at the same time.

Here are the settings:
Default open mode: Shared
Default record locking: Edited record
Not Open databases using record-level locking

C I Corporation
202-829-4444
800-DATA1OK

Return

.