.mdb to .accdb back-end

[topher23]

This may seem odd, but is it possible to connect an mdb to an accdb back-end?

[Megalog]

Tried it, got this:

"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."

So, apparently not. The opposite does work though. (ACCDB FE to MDB BE)

[topher23]

That's what I feared. I suppose I'll have to do some front-end updates to use the new Outlook mail forms in Access 2007.

[NeoPa]

As you are essentially expecting the Access 2003 (or earlier) software to interpret data stored in a file that it knows nothing about, this will not work (This much you already know).

It may be worth trying this using the Access 2007 software to open the MDB file. I suspect in such a scenario it may work. Possibly worth a try depending on your requirement.

[Megalog]

It may be worth trying this using the Access 2007 software to open the MDB file. I suspect in such a scenario it may work. Possibly worth a try depending on your requirement.

Neo, I did my test using 2007.

[NeoPa]

Well, there's the answer then ;)

Never mind. Worth a look I'd have thought.