dtlmcburg
asked on
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
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
try clicking debug and post the lines of code you see..
ASKER
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
error-430-2.bmp
What is "con" defined as? It is a ado connection but might be worth checking it has been defined correctly
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
Closed
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