Sorry, what I meant was I added auto datetime (i set as not visible) and I recreate my backend. But I did not recreate the accde so my backend did not save the datetime
You need to save your existing accdb, and create a new accde
You really want to have a virgin unused copy of the accdb, in the event of any problems. You don't want to be trying to reuse the accdb and find it's corrupt.
I save multiple archive versions of databases so I can go back to an earlier version if necessary. maybe to recover code that was deleted in error.
mydbs_v1.1.accdb
mydbs_v1.2.accdb
mydbs_v1.3.accdb
You need to save your existing accdb, and create a new accde
You really want to have a virgin unused copy of the accdb, in the event of any problems. You don't want to be trying to reuse the accdb and find it's corrupt.
I save multiple archive versions of databases so I can go back to an earlier version if necessary. maybe to recover code that was deleted in error.
mydbs_v1.1.accdb
mydbs_v1.2.accdb
mydbs_v1.3.accdb
I don't believe there was any corruption
The problem was just that you hadn't saved the BE password when you created the link
Below are the results of a query on the MSysObjects system table before & after I relinked the table
The query SQL is
Code:
SELECT Name, Type, Flags, Connect, Database
FROM MSysObjects
WHERE Database Is Not Null;
The Connect field is used to store the connection details - type of file (MSAccess) & password (123)
However it was blank in the file you uploaded so clicking the linked table originally gave the 'not a valid password' error message.
EDIT: Obscured the Database path at the request of the OP