Using MS Access 2019 to deploy an .accde form that I developed.
It checks the value of the current form's version from a .tab text file that is hosted in a shared folder and imported as a linked table into the DB.
This works in the .accdb but in the .accde version throws error 3625:
The text file specification 'X' does not exist...
Code for reading data from file (this is inside a Module):
Public Function checkVer()
Dim ind As Boolean
ind = DLookup("[ACTIVE]", "Ver", "Ver = '9'")
If Not ind Then
MsgBox "This version is obsolete. You may get the latest version from the shared folder."
Application.Quit acSaveNo
End If
End Function
How the function is called:
Private Sub Form_Load()
checkVer
End Sub
Any help is appreciated...
I tried deleting the file specifications records from the MSYSImexSpecs table, deleting the linked table and reimporting the file as a linked table again, Compact and Repair, a full decompile and tested successfully the functionality in the .accdb version of the form.