Printable View
dear all;
am trying to open an Access Database, it gives me the following message:
"The expression On load you entered as the event property setting produced the following error:
A problem occured while Ms. Office Access was communicating with the OLE server or ActiveX control"
and that message appears every click, resize, close...
can anyone plz tell me whats the problem.
Is it just on one database or all? Did you add any code or add any
custom properties to the db? What version of Access?
Am using Access 2003, i also tried XP and 200.
As 4 the access database, am new to VBA (my 1st task in it) it is a complete access application (forms, queries...etc) i tried opening it on another computer, the same error msgbox appears...i took another version from my boss, which he showed me its working, and run it from my computer.........again......the problem remains.
i have win xp sp1, access 2003 with all features installed, vb6 with sp5, and .Net framework!
plz help!
Could it be that the "On load" procedure should be "OnLoad"?
So "On load" is not a custom property you added to the
database? Could you post some relevant code? the other
computers that it doesnt run on are running what version of
Access and Windows? Do you have any code referencing any
other databases or COM object references?
Thank you for your interest;
The problem is that am not able to open the code, i tried XP and 2000, i was told that it runs normally under these platforms, i also tried access 2003 and XP, but still the same problem!
Its not only the load event, its in every click of the application, resize....etc........i tried everything...what could be the problem?
by the way.....nice MCP logo........i got my MCP in c#.net two days ago (980/1000)
Thanks, and congrats to you too on a great scrore. I got 928/1000 VB6 70-176. :(
You need to determine where the issue is buy narrowing down
the possibilities. Can you step through code where you think the
problem may be. Start with the first form that is giving you
problems. Open it in design mode and check the property "On
Load". What does it say and what does the procedure look like?
http://www.vbforums.com/attachment.p...postid=1804936
Yes....thats exactly whats going on.
When i run SOME of the forms, and the MAIN form, the error message appears
Sounds to me that the comp where the database was build on had an ActiveX compinent installed which was used in the database, so if you run it on an comp without that ActiveX it gives this error.
OK,
But which ActiveX?
I tried WinXP SP1, Win2000 SP3
I Already Installed: VS6, VS.NET and tried: Office 2000, XP, 2003!
What else can i do?
Since we can not see your forms and code, all I can say is if you
can check on one of the systems where it does run, to go into
design view and see if you added any external controls to the
forms. Did you click on the toolbox - more controls ? If you did
then it could be possible that you added an external control from
there.
There's no new controls, or anything special!
Could it be am unable to run macros? or anything else?
am going crazy here.......it doesn't make any sense
WHy not post the database somewhere and let others checkQuote:
Originally posted by FiDz
There's no new controls, or anything special!
Could it be am unable to run macros? or anything else?
am going crazy here.......it doesn't make any sense