I have several MS Access databases with tables containing fields that were set to the Data Type "Double" with decimal places set to "Auto"
Access somehow changed all these fields to the Data Type "Decimal". When my users tried to run imports, an error message was displayed saying the decimal field's precision was too small to accept the data
I resolved this easily enough by switching the Data Type back to "Double". But, does anyone know why this would happen? Why would Access change the Data Type to Decimal and set its own parameters for the Precision? It caused the app to fail
Is there any way to prevent Access from doing this?