Avatar of TSIsolutions
TSIsolutions
Flag 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? 

Microsoft AccessVBA* Webcam

Avatar of undefined
Last Comment
Jim Dettman (EE MVE)

8/22/2022 - Mon
Jim Dettman (EE MVE)

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.


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
Jim Dettman (EE MVE)

<<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.


All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
TSIsolutions

ASKER
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.

John Tsioumpris

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.
TSIsolutions

ASKER
Thanks John :)
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
TSIsolutions

ASKER
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?
Jim Dettman (EE MVE)

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.


TSIsolutions

ASKER
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 started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Jim Dettman (EE MVE)

<<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.
Jim Dettman (EE MVE)

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.
TSIsolutions

ASKER
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?
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.