Access 2007 error 3845 when linking mdb file

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • hivdb2@gmail.com

    Access 2007 error 3845 when linking mdb file

    Hi all, I have an app developed in Access 2000/2003 (2000
    compatible). I have a routine to refresh table links. Both files are
    MDB files (the front end and back end). The code I use is as follows:

    DoCmd.TransferD atabase acLink, "Microsoft Access", datafile,
    acForm, table, table

    datafile = "c:\mydir\mybac kend.mdb"
    The file that contains the code is c:\mydir\myfron tent.mdb

    I believe this message is supposed to appear when linking to the more
    modern Access 2007 format (ACCDB) from within an (older) mdb file. I,
    however, am using MDB for both files but get this error. Does anyone
    else know what the issue is? I can't find anything on the web... :(

    Full message is:
    ---
    Run-time error '3845'.

    Microsoft Office Access does not support linking to an Access
    database or Microsoft Office Excel workbook saved in a format that is
    a later version than the current database format.
    ---

    Any help would be appreciated!
Working...