ms access how to use dbase files in access after ms stops support in access 2k10?

I have numerous dbase legacy systems that go back decades and could not be re-done, practically. does any one know of any third party or freeware utilities to work around this issue?
jsgouldAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
The only work around I've seen is to install SQL 32 bit, then using the VFP drivers, create a linked server to the dbase files with SQL.

Time to move that data!

Jim.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
If you use Access 2007, you will still be able to use the old database formats.  Better, however, as Jim suggested, to move the data ~ and the logic.
PatHartmanCommented:
I am linking to FoxPro from A2013.  I'm pretty sure it works because the old drivers were there from a previous A2010 install.  It sure surprised me when the links continued to work.

You can try to use ODBC to connect rather than the former method which listed dbf's as a separate option.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Adding on to Pat's two points a bit:

1. You can try installing the A2010 Redistributable, which should give you the drivers:

Microsoft Access Database Engine 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=13255

2. You can use any ODBC driver and work with it that way; doesn't have to be Microsoft's.  Not aware of any off-hand, but there's probably some out there (although many did rely on the Access drivers).

Jim.
Jeffrey CoachmanMIS LiasonCommented:
What is your ultimate need here?
What is your current system is structured to do?

Are you saying that you are no longer using the dbase environment?
If this is the case, then keeping the data in the dbase format is going to hold you back.
No workaround or third part app will be 100% feature compatible.  All that will do is add another layer of complexity between your data and your UI/functionality.
If you are already linking to Access, ...then what's stopping you from migrating the data to: Access, SQL, or MySQL?

I have numerous dbase legacy systems that go back decades and could not be re-done, practically.
Define "practically".
From the Wikipedia page:
https://en.wikipedia.org/wiki/DBase
...it states that dbase still keeps it "environment", updated.
So we also need to know if you are just linking into a legacy system (with static data)
...or does your current system still continually "update" the old dbase system?

If you do a Google search of "Migrate dbase"
...you will get a host of products and services that will move your data to another system.

JeffCoachman
PatHartmanCommented:
Moving the data doesn't help if the app is still operational.  My client is still actively using a FoxPro system.  I replaced a lot of it but over the years, they cloned the basic app and made changes.  Some day, I'll incorporate those outlier apps also.
Dave BaldwinFixer of ProblemsCommented:
My main client still uses Visual FoxPro 9 (VFP9) because he can write his own programs.  He runs his business and 4 web sites on it and is not likely to change anytime soon.  Some data gets converted to MySQL for the web.
jsgouldAuthor Commented:
Thanks all for the response
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.