Access 2007 and linking databases

[mancombseepgood]

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 the error I get is supposed to relate to 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.
---

 

[|tera|]

The error is pretty self explained I think. You can't link to a newer Access or Excel file from an old Access version, which sucks in my opinion. You'll have to make the backend file with Access 2007 as well, or maybe you can just convert it?