Results 1 to 3 of 3

Need help on Access Attachments Migration to SQL server 2014

  1. #1
    sahadevreddy@gmail.com is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2016
    Posts
    2

    Need help on Access Attachments Migration to SQL server 2014

    Hi All,



    Good Day, I am trying to migrate my Access 2013 database to SQL server 2014. I used SSMA to do the same. I am stuck with the Attachments type.All the data is moved except the attachments. I would like to know if there is any option to Store the documents in SQL server and retrieve them when required.

    Thank you very much in advance for your help on this.

    Best Regards,
    Saha

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    4,766
    Store the attachments in file folders. Store the path to them in the table.

  3. #3
    sahadevreddy@gmail.com is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Dec 2016
    Posts
    2
    Hi Ranman,

    Thank you very much for the response. I have multiple forms(used to feed the tables) with attachments in my DB. So Can we do that for all of them and have one single file location. If yes, kindly advise me on how to do that as I am novice to Access and still learning.

    Best Regards,
    Saha

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-11-2016, 07:25 AM
  2. Replies: 8
    Last Post: 11-05-2015, 05:06 AM
  3. Query not working after migrating to SQL Server 2014
    By Esmatullaharifi in forum Queries
    Replies: 7
    Last Post: 04-18-2015, 04:21 AM
  4. Replies: 3
    Last Post: 05-07-2012, 06:57 PM
  5. Access To SQL Server Migration
    By Rxp in forum Access
    Replies: 6
    Last Post: 05-07-2012, 04:50 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums