Microsoft Access
HELP

Sources for Quick Answers

Microsoft Access
Microsoft Access site

Google
Advanced

Questions from Users

Topic

Question & Answer

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