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.TransferDatabase acLink, "Microsoft Access", datafile,
acForm, table, table
datafile = "c:\mydir\mybackend.mdb"
The file that contains the code is c:\mydir\myfrontent.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!