• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 480
  • Last Modified:

Getting Run Time error 430 when attempting to access MS Access 2003

I have one user who is running in to the following error message Run-time error 430: Class does not support automation or does not support expected interface when she attempts to use Microsoft Access 2003 database (.mdb). Other users in the organization do not have any problems access the same database using Microsoft 2003.

Some of the things I have attempted is reinstall Microsoft Access on the users pc, and update the MDAC file to v2.8 but failed to resolve this problem.   The users pc is Dell d600 Laptop using Microsoft XP SP2 with all the current patches installed. Does any body have any ideas?

430-error.bmp
0
dtlmcburg
Asked:
dtlmcburg
  • 4
  • 3
1 Solution
 
rockiroadsCommented:
Do you use any activex controls in your app?
Maybe whatever you use requires registering on that PC

If you can get to the vba editor, select menu option Tools, then select references.
You should see a list of items, some ticked. Out of those ticked are any listed as MISSING?

It could be that you have the file there but not registered with windows, this is relatively easy to do as we just need to use regsvr32
0
 
Surone1Commented:
try clicking debug and post the lines of code you see..
0
 
dtlmcburgAuthor Commented:
checked the Reference option but it was grayed out in VB editor. I have attached a screenshot of what VB editors shows.  
error-430-2.bmp
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
rockiroadsCommented:
What is "con" defined as? It is a ado connection but might be worth checking it has been defined correctly
0
 
dtlmcburgAuthor Commented:
The person who created this database is no longer with the organization So I am not aware of most of the coding . I dont believe there is an issue with database it self since it can be accessed by other users. One user is question using Dell D600 Laptop w/XP sp2 is not able to access any ms access database regardless of the user who is log on. So I not for sure if this is more of a setting on device or something else related to users laptop....... Thank you for all the help you have given me.
0
 
rockiroadsCommented:
ok, well on his PC, make sure mdac is up to date, that might be an issue
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
0
 
dtlmcburgAuthor Commented:
I updated her MDAC file with the latest version, rebooted her laptop, and got the same message real time error 430 on user laptop. I used multiple version of MDAC (i.e. 2.6, 2.7, and 2.8) file in hops of may be compatibly issue but end up getting the same message.
0
 
dtlmcburgAuthor Commented:
Closed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now