If I'm looking to build a database, what's better (looking at specs below) Access or FoxPro? I posted a question a few weeks ago but had suggestions of using other packages. Logically I'm restricted to using either of these 2 packages. The program is currently in FoxPro (very poorly) but I know Access relatively well so it's a matter of going off to learn FoxPro & fix the database in FoxPro or increase my access skills and convert it (with some help from "Holly")??? Does anyone also know where Microsoft is heading with both?? Some people have told me not to bother with Access as in their words "it's just a toy" but others have told me to steer clear of FoxPro (one person even telling me Microsoft if not supporting it even though they are about to release V8!).
The program currently works as follows (Not overly complex, but not a toy either):
We are a gift company and enter orders that include where order has come from, gift code, sender, recipient, message, delivery date, etc. We currently have a names database containing our clients (using client codes) and the orders are maintained using the clients codes, not full client data). We also have the ability to run reports, accounts, etc. We print the despatch labels, barcodes & manifest for the courier company.
I want to introduce the ability to import orders straight into the system from set file formats, rather than data enter all orders (as happens now).
The program needs to be shared with several data entry operators working at once on the system.
Love to hear your thoughts