Error converting FoxPro 2.5 database to Access 2000
Posted on 2000-04-19
I'm a novice still seeking advice. Can anyone tell me how to convert (or update) an old FoxPro DBF I'm having trouble with? I'm not sure what the probelem is. I'm helping out my in-laws trying to fix their database program that went down because of Y2K. It's a stand-alone DOS Record Keeping program that is set for a small office network. The front screen says, "FoxPro 2.5 exe Support Library (X)."
First and foremost, it needs to be made Y2K compliant. Secondly, it needs to be updated from a DOS shell to a Windows app. They do not have the FoxPro 2.5 program per se, just the stand-alone database program that apparently was created by it. At the moment I am having trouble trying to open or convert the DBF files in Access 2000 for them. Could this be a locked database?
Here's what I get when I ty to open the file or convert to Access 2000... (all rookie stuff I'm sure)
1) IMPORTING THE FILE FOXUSER.DBF WITH ACCESS:
I go to FILE... GET EXTERNAL DATA... and then IMPORT... I get an error message that says, "Access was not able to perform this operation because the project is not connected to a SQL server database."
2) DOUBLE-CLICKING ON THE FILE FOXUSER.DBF:
"Unrecognized database format"
3) OPENING THE FOXUSER.DBF FILE IN ACCESS 2000:
I go to FILE... OPEN... then select the file FOXUSER.DBF. I get two diferent errors that say...
"Cannot locate the requested xbase memo file"
"Microsoft Access can't open the table in Datasheet view"
The MS Knowledge Base says, "You tried to access a dBASE (.dbf) file, but the file's associated memo (.dbt) file could not be found. Make sure the .dbt files is in the same directory as the .dbf file, and then try the operation again."
Okay, I told you up front, I am a novice. I'm certain this is apparent by now. <g> I've only done ONE Access database in my life and have been kind of pushed into this in an effort to help out one of my in-laws. I would like to find the easiest way to get their database Y2K compliant, plus put it into a newer Windows program like Access 2000 if possible. The trick is, if I use Access 2000 how do I get the old DBF files to import?
I would sure appreciate any input on this one. It may be a very simple fix for most of you, I really don't know. What I do know is that I'm over my head in helping out the inlaws. :o(
Last but not least... if they were to purchase the New Visual FoxPro 6.0, wouldn't that update everything much easier? I assumed at first blush that it would be a normal version upgrade but the folks at Microsoft actually said it would probably be better in Access now. The data being handled is nothing extraordinary, just simple PIM, billing and time tracking stuff. I am hoping for a quick easy conversion that can be made Y2K compliant and runs on a new Windows app like Access 2000 or maybe even Visual FoxPro 6.0. (Easier said than done?)
Is any of this possible at all???
Thanks for any advice! :o)
PS... I don't know about the points well enough to know if this is easy or hard. I suspect easy but please tell me.