ACCDE error 3625 The text file specification 'X' does not exist

82 views Asked by At

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.

0

There are 0 answers