
	Quick Find:		Search for:

Free Resources from FMS
Demos Email Newsletter Technical Papers Tips and Techniques Links Book Recommendations Microsoft Access Resource Center



"Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities." - *Darren D.*

Ensure Field Data Types Are Consistent Across Tables

Provided by: Dan Haught, FMS Executive Vice President

If the same field name is used in multiple tables, there's a good chance that the fields all refer to the same data point. In these cases, each instance of the field should have the same data type and size. For instance, a Customer ID field could occur as an AutoNumber field (long integer) in one table and an integer or double in another. Inconsistencies like this can lead to problems as data is moved from one table to another or queried. In extreme cases, inconsistent data types can even lead to data loss as Access or VBA tries to convert between different types.

Return to the tips page.