Access 2016 OLE Object *CALLING ALL DB ADMINS!*

[Netwacky87]

Hi all!

 

I have a small database project going on. I will explain the background. We have recently had SALTO Door Access control fitted. It runs a SQL Server DB.

 

When it comes to printing out ID Cards, its a LONG process of clicks and frankly when you have a year group to do - my hand gets pretty damn tired!

 

Soooo my idea, use Access to create a small db that can print the cards quickly in bulk. I'm no SQL/Access expert but i've managed most things but one thing i cannot do is print out the users' picture. Pictures seems to be sitting in a table thats an OLE Object. I cannot seem to get it to display in either a form or report.

 

Anyone know what I need to do, or doing wrong? After a bit of googling' it seems like I need to make a Bound Object Frame but after that i'm stuck.

 

This will save me soooo much time and effort! Any help appreciated!

[azureusnation]

If you can, could you create a test picture and then get the row of the picture in the db and spit it out here. Ill then see what file format it is.

[Netwacky87]

I think I know what you mean...if I go onto the table design view on SQL Server it says the data type is 'varbinary(MAX)'