Hello,
My company uses an Access database that is split into a front and back end. It always seems to take a long time to load and create/export reports. Would limiting the field sizes of tables in the back end make queries run faster at all? There is currently no limit set for any of the fields. The current size of the back end is around 25,000KB. Also, if I reduce the field size too much for any data currently contained in a column, will that delete the entire row of data, or just the information in that column for that specific row?
Thank you!