One issue is several of the tables in the access database do not have primary keys. I did not design this monstrosity.
The sql server does not have access installed, so trying the ACE drivers has merit/ The version of access we are using is 2010.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.