A client has reported getting the “You can’t save the record at this time” message several times over the last two weeks. The user reporting this error indicates there are no other users in the application when the message is thrown.
As a developer I have gotten this message over the years. It usually occurs when trying to save when all the validations required on the record are not fulfilled. Are there other reasons this can occur?
I developed the application that is generating the message over 12 years ago. Up until last week they hadn’t encountered that message. There have been no application changes in at least two years.
Setup: Each user has a copy of the frontend ‘TravProc.mdb’ on their local machine. The backend ‘TravData.mdb’ is stored on the server. All front end mdb’s are linked to the backend mdb.
Prior to receiving the message last week, they had reported receiving an “Unrecognized database format’ error on the backend mdb ‘TravData.mdb”. To handle that situation I created a new blank MDB and imported the entire backend MDB. I then renamed the old backend, replacing it with the new rebuilt backend mdb.
The rebuild stopped the message for a couple days but now the “can’t save the record’ message is re-occurring. The “unrecognized database” message has not re-occurred.
Seems odd that after 12 years they are encountering this message making it unable to save changes they are making.
Over the years I developed and installed have 5 other Access for this client. All with the same model, front mdb, backend mdb. All users have a local copy of the front end mdb that is linked to the backend mdb on the server. None of the other 5 applications are having any issues.
Any ideas why this long running, up until now, stable application is encountering this message?