Help! We need some guidance from all you database guru’s out there! Here’s the scenerio, and it’s likely one you’ve heard before. I’m an IT Systems Tech and for years have been warning one particular department that they needed to convert a Visual dBase 4 database into something more current. Only one person knows the program and has little documentation. He tweeked as he went. His database is great and he’s been able to do all the reporting needed to meet the State of California requirements for the department. Now the other shoe has fallen, that individual is out on extended medical and unable to nurse the program along. So… A couple of weeks ago something happened and the database isn’t working. The department is not able to complete the mandatory State reports. A terrible nightmare for them, but one that we knew would happen; it was only a matter of time. Now we’ve been asked to help. We have a meeting with the departmental players next week.
My questions of you all… Are there any conversion tools commercially available to convert to Access? Is Access even the best way to go? The department does have Office 2007 Professional. I’d like to try to find a commerical database, but likely nothing is quite like what they have and funding is limited.
We are open to your ideas and suggestions. Thanks in advance for putting on your thinking cap for us!