Solved

eztwain driver crashes msaccess when trying to access scanner in vba

Posted on 2012-12-25
11
907 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
11 Comments
 
LVL 51

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 51

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
LVL 51

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 51

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 51

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

Get HTML5 Certified

Want to be a web developer? You'll need to know HTML. Prepare for HTML5 certification by enrolling in July's Course of the Month! It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

623 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