Hi all
We currently use a split A2k database system with about 10,000 clients
/ 45,000 orders / 90,000 order entries etc with about 17 users (only 8
users do editing)
We currently upload data to a internet search engine via a 4d database
by means of exporting text files from access into 4D and then uploading
to the web, however the web site search engine needs a major overhaul
as it currently sees data in a flat file format only which is
cumbersome for searching etc
The access system has grown into a bit of a monster and probably needs
to be re written, however before we undertake this I wondered if it
would be about time to upgrade the back end
Has anyone got any upgrade advice on changing the back end from
Access/jet to something like MySQL or SQL Server (or soemthing else)
bearing in mind the learning curve involved.
i am still keen to keep access as the front end
many thanks
Steve