MS Access - Form - Autocorrect save failures

Question

Hi,

I've got a Data table that I import an excel file into, it works great, all the information from the file goes into the table but another table has appeared called:

"Name Autocorrect save failures"

A new entry appears every time I Import giving the table name, object type, reasons for failure, and time. The reason for failure is "could not save the object" but all the info is in the Data table. 

Can anyone help me in this?

Thanks in advance.

Answer 1

For anyone following this is a cross post from the answers Fortin, see https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-msoffice_custom-mso_2013_release/ms-access-form-autocorrect-save-failures/f8fc0f4d-af58-4b30-aa29-ae7995916549

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Hi Wsm93,

Did the suggestion from Daniel work for you?

Could you share us your excel file, then we could try to reproduce your issue?

Best Regards,

Tao Zhou

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Hi,

Was testing some stuff. No it didn't work. How cani share the excel file can you let me know?

Thank you.

Answer 4

You need to upload it to a cloud storage (Dropbox, OneDrive , ... ) and provide us with a link to download it.  Obviously, we'd need the database and the Excel file.

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net