Solved

Access 2003 Error: -2147467259 - Unspecified error

Posted on 2013-12-04
3
579 Views
Last Modified: 2013-12-15
Hi all.

I get the following error: Access 2003 Error: -2147467259 - Unspecified error

at the itm.Transfer part of my VBA code:

Dim itm As WIA.Item
Dim img As New WIA.ImageFile
Set img = itm.Transfer

This is only happening to one computer, all the other ones are ok.
All computers run the .ade file.

What can I do to fix this?

Thank you in advance.
0
Comment
Question by:Sim1980
  • 2
3 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 39697820
Try checking your references and comparing them between the computers where this works and the one where it doesn't work.

From the VBA Editor:

Tools --> References

Make sure that the problematic computer has the same references checked as the other computers and that none of the references are labeled as MISSING.
0
 

Accepted Solution

by:
Sim1980 earned 0 total points
ID: 39697944
But since the file is an ade file, shouldn't the references already be there? Also, the computers do not have the full version of Access, they have the Access Runtime.

When on the computer, it does not show the Tools --> Reference option. It's because they have the runtime.
0
 

Author Closing Comment

by:Sim1980
ID: 39719747
I reformatted the computer and it works now.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

776 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