Link to home
Start Free TrialLog in
Avatar of TSIsolutions
TSIsolutionsFlag for Canada

asked on

MS Access webcam picture issue

Hello Community,


We have an MS Access application which takes pictures of products via webcam.


We are currently using a popular module connecting to avicap32.dll to open the webcam and capture a frame. This works properly.


However we have been having problems on certain tablets where the cameras are not detected. To test the issue, we open Windows 10 Camera app and it works fine (front and back). However, when we use the vidcap32.exe application to test it, we can select a video source (front or back) but once we do, we get a "capture device not detected" error message.


Has anyone encountered this issue? Why is it that Windows 10 App sees it and avicap32.dll does not? What can we do to correct it?User generated image 

Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

My first stop would be to check the privacy settings for the camera (settings/privacy, and under app permissions, camera)

Make sure the:
"Allow access to the camera on this device"
"Allow apps to access your camera"

and

 "Allow desktop apps to access your camera"

are all on.

Jim.


Avatar of TSIsolutions

ASKER

Hi Jim,

   Thanks for the response.
   Sorry I didn't mention it before but that was already done.

   Any other suggestions would be greatly appreciated
<<However we have been having problems on certain tablets where the cameras are not detected.  >>

 What tablet specifically are you having a problem with?

Jim.


We have a client with a few Lenovo X1 Gen1 and Gen2 tablets.
But I’m not sure if it’s a driver issue (if that’s what you’re thinking) since the cameras work properly with Windows 10 Camera App.

If I remember correctly there are some cameras that are incompatible due to architecture with avicap32.dll
I have done a post some time ago with a sample Access application that had camera working....let's see if I can dig it up.
Thanks John :)
Hi All,

Checking posts online, I see more and more devs having an issue with connecting avicap32.dll to tablets with front/back facing cameras.
I tested on our tablets using an external camera and it worked properly.
Is there a limitation to avicap32.dll when it comes to integrated cameras? Is there a workaround?
I hadn't had a real chance to dig into this as yet, which is why I hadn't commented again, but yes, that's the same sense I got.

avicap32.dll is a very old Dll, and given that, might not support more modern hardware.  I saw posts about it not detecting all web cams, which probably ties into you finding it not working with front/back cameras, which I would assume the system would see as two cameras.

  But I could not locate anything specifically that spelled that out.   Only that it should no longer be used, and DirectShow was a better bet.  That however is .Net based. Calling .Net code from VBA I have not done, although it's possible.  

 That's about as far as I got before I ran out of time.

Jim.


Hi Jim,

Thanks for the response. I'm surprised nobody has ever create a module that ports .Net DirectShow to vba.
I'm not a .net developer so not sure if it's something i could tackle. Especially that we have a client who wants to use our Access Application exclusively on Tablets.
Any documentation would be greatly appreciated.

<<I'm surprised nobody has ever create a module that ports .Net DirectShow to vba. >>

 That's because just about anything written in .Net is built on classes in the .Net Framework, which is not directly callable by VBA.  So there's no easy way to port .net code to vba.

  What you'd have to do is write something in VBA.Net or C#.Net, then call that from VBA like you would call any other type of lib.

Jim.
Also keep in mind that while the desktop is certainly not dead, the world is heading towards the web and mobile in a big way.   There's not a ton of development in the desktop space like there once was.

Jim.
Thank all for responding. Can a solution be to call a camera app that uses Direct Show to take the images and then save them in a a desired location. Is there perhaps a camera app with command lines that we could use?
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial