Avatar of eg252
eg252
 asked on

eztwain driver crashes msaccess when trying to access scanner in vba

savin 4018 network twain driver.

I'm trying to scan in vba using eztwain.

with eztwerp (eztwain.dll) it opens and scans fine, but when i try to access the scanner using the dll in vba it crashes.
Microsoft AccessHardware

Avatar of undefined
Last Comment
eg252

8/22/2022 - Mon
Gustav Brock

You may need an ActiveX control for this.
Some are free, but I have used the cheap csXImage control:

http://www.chestysoft.com/ximage/default.asp

A link to an Access demo is located somewhere down that page. It will get you going.

When I worked with it some years ago, I learned that Twain drivers are animals of their own and - because of this - the support from Simon (the developer who knows just about everything about scanners) is a very big help.

/gustav
eg252

ASKER
i actually bought the csXImage control - and it  crashes the same. everything works until you try to scan. you can select the twain source, you can check if its connected, but when you try to acquire image it crashes up...  
When I use the ezTwerp program that comes with the eztwain.dll it works fine - perfect, but when i try to scan using the ocx or the dll it crashes..
I worked on this for hours and hours, was hoping there was someone out there that would know what im missing..
Gustav Brock

Very well.
Then, I guess, it is an issue with the scanner driver itself.
Did you address Simon about this particular scanner? In general, drivers from manufacturers are of "uneven" quality and manufacturers' support know next to nothing about implementation of their hardware.

/gustav
Your help has saved me hundreds of hours of internet surfing.
fblack61
Michael Carrillo

You might also want to try running Windows update to see if the newer dlls for Windows and office work better with this driver.
eg252

ASKER
no. there is a program eztwerp which is 40k and it works fine. i know that the dll should worrrk. every time i access it in access it crashed. there must be something im missing.. i need this to work.
Gustav Brock

But what are the comments from the manufacturer about their appearently buggy driver?
Perhaps it will only run under an old Windows version?

/gustav
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
eg252

ASKER
i just tried twainCom demo version and it also worked. Im not sure what the limitation is. If i bought the chestysoft already - i would want it to work as well.. im not sure when this demo will expire.. it must be something simple that im missing..
Gustav Brock

I would ask Simon about this.

/gustav
ASKER CERTIFIED SOLUTION
eg252

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

If you refer to TwainCommander:

http://www.jse.de/products.html#twaincommander2

the reason why it does not cause a crash, may be that it as a command line tool runs in another process not controlled by Access.

Anyway, thanks for the feedback.

/gustav
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
eg252

ASKER
no one was able to help me.. i found a different solution - not the one i was looking for.. but it works.