The database that comes with Office Professional. Access can handle tens of thousands of rows with ease and has great connectivity support for traditional database servers.
Access Removing Decimal Places
I've got a field in the DB to capture CPU speed. The guy who created it initally set it up as a Text field, we had issues sorting so we bumped it over to Numeric. The problem now is that if I have a 1.8Ghz machine I need to enter and I type in "1.8", it automatically rounds the number up to "2".
An ideal solution would be that only decimals showup with a decimal point (so 266mhz won't become 266.00 mhz for example).
Change the datatype from an integer to a Double. Should be able to be reset in the controls for the text box.