Solved

eztwain driver crashes msaccess when trying to access scanner in vba

Posted on 2012-12-25
11
887 Views
Last Modified: 2013-01-14
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.
0
Comment
Question by:eg252
  • 5
  • 5
11 Comments
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 38722217
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
0
 
LVL 1

Author Comment

by:eg252
ID: 38722511
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..
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 38723015
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
0
 
LVL 9

Expert Comment

by:macarrillo1
ID: 38738853
You might also want to try running Windows update to see if the newer dlls for Windows and office work better with this driver.
0
 
LVL 1

Author Comment

by:eg252
ID: 38743911
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.
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 
LVL 49

Expert Comment

by:Gustav Brock
ID: 38744016
But what are the comments from the manufacturer about their appearently buggy driver?
Perhaps it will only run under an old Windows version?

/gustav
0
 
LVL 1

Author Comment

by:eg252
ID: 38744230
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..
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 38744371
I would ask Simon about this.

/gustav
0
 
LVL 1

Accepted Solution

by:
eg252 earned 0 total points
ID: 38760369
simon was not able to help. in the end i went with TwainCom that works good
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 38760797
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
0
 
LVL 1

Author Closing Comment

by:eg252
ID: 38773827
no one was able to help me.. i found a different solution - not the one i was looking for.. but it works.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

What do we know about Legacy Video Conferencing? - Full IT support needed! - Complicated systems at outrageous prices! - Intense training required! Highfive believes we need to embrace a new alternative.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now