DBPix objects generating property and method related error messages in Access database

Dale Fye
Dale Fye used Ask the Experts™
on
I've got a client, who has an old Access 2003 database application that we are attempting to update to A2016 (32 bit)  (latest version she has).

She has about 8 forms in the application which use the dbPix activeX control, but we are getting errors on properties and methods which are documented on the companies web page.  I've checked the references and ensured that the ocx file has been added to the project.

I've replaced the dbPix control with an Access image control on one of the forms, which seems to work fine.  I'm waiting for info from the client as to whether she wants to proceed with this change on all of the forms.  

I have not dug into the code too deeply at this point, but as I understand it, one of the reasons for purchasing the software was to allow the users to connect a digital camera directly to their computer to capture and store the image.

1.  Does anyone have any idea why the code behind these forms would be failing with "object doesn't support this property" and other property/method errors?

2.  Has anybody used any other freeware that performs this same functionality?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Commented:
Well as i can see its about Image Handling...have you checked my Article...it handles images right on Access... :
https://www.experts-exchange.com/articles/33716/Defeating-the-device-independent-bitmap-dib-format.html
John TsioumprisSoftware & Systems Engineer

Commented:
Otherwise we will need some info about the errors you get...
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Dale,

 Usual deal...check references, make sure the OLE lib is registered (can you bring it up in the object browser), and failing that, a /decompile.

 On the references to, I would check any un-checked reference, compile and close, then re-open and un-check the reference.  That will force a refresh of the references collection.

<< Has anybody used any other freeware that performs this same functionality>>

  DB Pix had that part of the market cornered.   But as you found out, the new image control and the ability to control how images are stored in a DB went a long way to negating their advantage.

 Still, the lib has the edge in talking to cameras and performance of image operations.   I'd keep it if you can.

Jim.
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
BTW, Joe Anderson used that control a lot....might want to drop him a note.

Jim.
I have on occasion before when dealing with active X controls, and especially in upgrade projects found that it helps to
A) Decompile
B) Delete the control, then create it again.

Maybe I was just lucky, but those have fixed it for me in the past, and its has been one of those "hmm...not sure what happened, but lets just move on" moments.
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Author

Commented:
@John,

It wasn't just about displaying images, it was also about capturing images.  I still plan on giving your article a closer look and playing with that concept.

Dale
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Author

Commented:
Anders hit the nail on the head with the delete and add a new control.

I've been avoiding ActiveX controls for so long now that I had forgotten that I should be able to simply right click on the control and see an option in the shortcut menu to view the properties of the control.  I could not see that option with the controls on the current form.

I then added a new control
renamed the old one
gave the new one the same name as the old one

Opened the form, and everything worked.

Thanks again, Smiley!
Your welcome :)
John TsioumprisSoftware & Systems Engineer
This is a common problem with ActiveX and the most used solution..but without knowledge about the errors you where facing we were only guessing...at least for  one of us : " the Force is strong in you young Luke Skywalker"...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start Today