attachment data type in SQL Server 2014

[Esmatullaharifi]

Hello dears!
I have exported my ms access tables to SQL server 2014 and my tables field has attachment data type while SQL server 2014 does not support attachment data type, how to solve.
Thanks,

 

[GinaWhipp]

The only way to solve is to put the path to your documents/files in a Text Box and use a Command Button to open or a double-click event.

 

[Esmatullaharifi]

Can you write the full solution because I am new to access.
I mean that how I can puth the path and how design the button with code.

 

[GinaWhipp]

What version of Access? What is the name of the Text Box that will store the full path to the document.

You can also look up Application FollowHyperlink in Google, to see examples.

 

[Esmatullaharifi]

My MS Access is 2013 and the name of text box is photo.

 

[GinaWhipp]

In the On_Click event of the Command Button...

Application FollowHyperlink Photo

 

[Esmatullaharifi]

while using this code an error (compile error. Expected: end of statement) is displaying for me. how to solve, what is wrong.

 

[Esmatullaharifi]

i have found the error where the dot operator were missing but now that i write down the correct address of photo and then clicking on button the 7971 error is occurred what is the problem.

 

[GinaWhipp]

Oops, my fault, that should be...

Application FollowHyperlink Me.Photo

 

[555access]

Oops, my fault, that should be...

Application FollowHyperlink Me.Photo

Thanks Gina