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
Last Comment
Jim Dettman (EE MVE)
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
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.
What tablet specifically are you having a problem with?
Jim.
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.
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.
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.
ASKER
Thanks John :)
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?
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.
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.
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.
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.
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.
Jim.
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?
ASKER CERTIFIED SOLUTION
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.
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.