Rabu, 26 Maret 2014

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

 

Art-


Nope.  The Image control handles only pictures (jpg, bmp, etc).  I don't think you can bind an OLE Object control to varbinary in SQL Server.  You really need the equivalent of OLE Object on the Access side.

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 
(Paris, France)




On Mar 26, 2014, at 12:53 AM, Art Lorenzini <dbalorenzini@yahoo.com> wrote:

I knew that was too good to be true. I adapted it to my application and it worked great. But I also have to allow for them to do PDFs and it bombs when I try to pull it in. Any ideas? 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070
"Only those who will risk going too far can possibly find out how far one can go."






On Tuesday, March 25, 2014 4:55 PM, John Viescas <JohnV@msn.com> wrote:
 
Art-

Look at LoadPictureSample.zip in the 1_Samples folder on the group website.  The example was written for Access 2003 that didn't have a Control Source for the Image control.  In 2007 and later, all you need to do is set the contents of the bound field to load the image.

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 
(Paris, France)




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

John,

Would there be an example of this somewhere. Because the user will need to add images as well as view them. 

With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070
"Only those who will risk going too far can possibly find out how far one can go."






On Tuesday, March 25, 2014 4:36 PM, John Viescas <JohnV@msn.com> wrote:
 
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 
(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 (6)
.

__,_._,___

Tidak ada komentar:

Posting Komentar