Results 1 to 4 of 4

Thread: MS Access including VBA Code with SQL Server back-end

  1. #1
    Join Date
    Oct 2009
    Posts
    2

    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?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can move tables to sql with Access' upsizing tool, and modify code in Access to use sql tables.

  3. #3
    Join Date
    Oct 2009
    Posts
    2

    Clarification

    My MS Access is 2002 with a file format of Access 2000, SQL Server db is SQL Server 2008. Access returns a message that the upsizing wizard only works with SQL Server v6.50 SP5 or higher?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    Possible to upgrade access first?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •