2010 Links to 2003 MDBs

I am converting a large group of Access 2000/2003 .mdb files to 2007/2010 .accdb. Some of the converted files have links to other .mdbs. Eventually all will be on 2007/2010 but during the conversion we would prefer to be able to maintain the links from the .accdb files to the .mdb tables until we finish the conversion.

Will the links from an .accdb file to an .mdb file continue to work?

Thanks.
Buck_BeasomDatabase DesignerAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
There is nothing obvious in your post to suggest the applications would not continue to work as normal.

But you have to test each one as you convert the frontend.  It is the detail of each application that will matter in the end and obviously it is possible that an existing app uses something 'non-standard' that doesn't convert.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
You'll have to change all the links from this format:

"path of Access file"

to this format

"path of correct Acccess app.exe" "path of Access file"

and if it asks you for the workgroup (security) file

"path of correct Acccess app.exe" "path of Access file" /wrkgrp "path of .mdw file"
0
 
Buck_BeasomDatabase DesignerAuthor Commented:
Where do I do this? The links were done using the Linked Table Manager, and that just asks you to locate the folder and file where the .mdb holding the linked tables are.

Thanks.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Disregard my first comment.  I interpreted 'links' as URL's, and not linked tables.

Have you tested this to verify that an Access 2010 app can/can not have a linked table to an Access 2003 app?  I don't have any experience with this, but off the top of my head I would guess that linked tables are backwards compatible.
0
 
Buck_BeasomDatabase DesignerAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.