Re: [MS_AccessPros] Work with images with Access using a SQL Server backend.

 

Art-

If there's only one attachment per record, then substitute a text field that contains the address of the image on the server.  If there are multiple images per record, then you have to do what Access does behind the scenes - build another 1-M table to contain the links.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Mar 25, 2014, at 10:19 PM, <dbalorenzini@yahoo.com> <dbalorenzini@yahoo.com> wrote:

I am currently using Access 2013. I have migrated the backend to SQL Server 2008 R2. In a number of tables I have an attachment field which can contain images or scanned documents. I am asking how I should handle them since there is no attachment type in SQL Server. Is there any examples on how to handle these attachments? The images our stored on a different server.

Thank you

Art Lorenzini

Sioux Falls SD

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___