Pat, I have Access 2010 and it has the ODBC import icon so if Approach is compatible then it should work - I'm going to suggest to my client he update to Access and I would like to know how much of the front end it will convert.
WL - regards your front end - I don't have a lot of experience with Lotus Approach but access converts 0% of any front end except from previous Access versions. This is not a weakness of Access all development environments are sufficiently unique that front ends are universally non automatically transferrable.