The note under Microsoft Visual Basic for Applications entitled "Review of the Data Type Summary: Floating Point Numbers" concludes that 99 billion is the highest decimal number that can be stored in an Access (DAO) database. This is true only under the following conditions:

The use of the CCur() is ruled out because its behavior changes with the Regional Settings of the operating system.

One or more numbers in the database will require accuracy out to four decimal places.

The use of CDbl() cannot be ruled out because the design requires a type conversion function.