-
MS Access including VBA Code with SQL Server back-end
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|