<div>
I was afraid that was the solution I was going to get. &nbsp;That's more effort then I am willing to put into this one. &nbsp;I am going to take a more manual approach and use it as a teaching tool. &nbsp;Thank you for the quick response.
</div>


<div>
<div class="content wysiwyg-content">
One of my departments has created an Access 2010 database. &nbsp;One of the tables has a column where they have stored pdf attachments. &nbsp;The column contains hundreds of attachments and the database is at the 2GB threshold, with many rows containing multiple attachments. &nbsp;Is there a way to extract the attachments and replace with links to a file location? &nbsp;I also have the option to migrate/upsize to SQL 2012, but I haven't found a way to easily get the attachments to migrate.
</div>
</div>


One of my departments has created an Access 2010 database.  One of the tables has a column where they have stored pdf attachments.  The column contains hundreds of attachments and the database is at the 2GB threshold, with many rows containing multiple attachments.  Is there a way to extract the attachments and replace with links to a file location?  I also have the option to migrate/upsize to SQL 2012, but I haven't found a way to easily get the attachments to migrate.

I was afraid that was the solution I was going to get.  That&#39;s more effort then I am willing to put into this one.  I am going to take a more manual approach and use it as a teaching tool.  Thank you for the quick response.

Extract Attachments from Access Database

One of my departments has created an Access 2010 database.  One of the tables has a column where they have stored pdf attachments.  The column contains hundreds of attachments and the database is at the 2GB threshold, with many rows containing multiple attachments.  Is there a way to extract the attachments and replace with links to a file location?  I also have the option to migrate/upsize to SQL 2012, but I haven&#39;t found a way to easily get the attachments to migrate.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.