Note that typically the reason this happens is that there is code behind the datasheet form that modifies properties on the form or controls (e.g. Textbox.Locked). Access intends to save the datasheet column widths without saving the properties changed in code, and that process was not working as expected. We are planning to fix this, but in the meantime, you may be able to work around this if you can avoid changing form/control properties in code (e.g. by using Conditional Formatting instead)
An error occurred while saving the commentJohn G. commented
I hope it's OK to piggyback on this subject. I have a database with many queries and macros. Our procedure to run this database is to copy data from an Excel spreadsheet and paste it into a table. Both the Excel template and the table in the database are in the same order regarding field names. We then run a macro to build a load file which is then exported for processing in other programs.
The problem we have, is, many times after we run the macro and try to use the database again, the order of the columns have changed and we can no longer copy/paste from the Excel template to the table.
Is there anyway to lock the table in the database to prevent the columns from rearranging on their own?
Thanks in advance.