I have a MS Access front end that has VBA code for such things as importing flat files, excel files, etc. Access also includes pass-through queries for data iporting from SQL/Oracle db's. I am running out of space with Access so need to incorporate SQL Server for upsizing.
I have tried the SSMA tool but this only creates a linked table in the Access db which causes the VBA code to fail.
I am trying to find a solution that will enable me to have the functionality that exists in Access (rather than re-developing in another language) and the storage capability in SQL Server, with minimal need to import in SQL or use the Linked Table Manager in Access.
Any Ideas?