I have a CRM which uses MS Access 2000, and the developer no longer supports the DB on a MS Access Platform. I need to convert from MS Access to SQL and despite my best efforts and those of the developer we don't seem to be able to find a solution.
They have tried the upsizing wizard, but this didn't bring across the history notes for each record which is the single most important data. I have tried the server migration assistant for access 2005 and whilst all the data is there, it seems to have renamed all the keys, meaning the database cannot be written to by the front end application.
I would like to find a preferably free way to bring the data across, I am neither an expert in access or sql, but do understand the basics of databases such as tables records, primary keys etc.
Would appreciate any assistance anyone can offer.