469,159 Members | 1,482 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,159 developers. It's quick & easy.

.mdb to .accdb back-end

topher23
234 Expert 100+
This may seem odd, but is it possible to connect an mdb to an accdb back-end?
Dec 22 '09 #1
5 4282
Megalog
378 Expert 256MB
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)
Dec 22 '09 #2
topher23
234 Expert 100+
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.
Dec 22 '09 #3
NeoPa
32,167 Expert Mod 16PB
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.
Dec 22 '09 #4
Megalog
378 Expert 256MB
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.
Dec 23 '09 #5
NeoPa
32,167 Expert Mod 16PB
Well, there's the answer then ;)

Never mind. Worth a look I'd have thought.
Dec 23 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Peter D. Dunlap | last post: by
4 posts views Thread by Hypo | last post: by
29 posts views Thread by Tom wilson | last post: by
4 posts views Thread by ARC | last post: by
4 posts views Thread by MrDeej | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.