Can't work this out - Probably VBA related errors

corpuschristi

New member
Local time
Today, 18:00
Joined
Jun 23, 2008
Messages
4
It goes like this. ANY database i try to run on my laptop, gives the following error, whenever a form/controller attempts to call a subroutine, or whatever other actions involving VBA code: "A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX control".
Furthermore, when i create a totaly new database using my laptop, when i try to link a form event to a subroutine, I get this error: "Microsoft Office Access failed to create the Visual Basic module". When I write the code to the event in the VBA window, it compiles just fine, but when attempting to run it trough the form, I get the OLE server error again.
Google-ing it, i found no reference to a working solution to these errors.
At first, i was using Windows 2000 SP4 platform with Access 2003 runtime. I then installed Access 2002, with same messages appearing. I went on and installed Access 2003, nothing changed. Frustrated, I went on even further and formated, installed Windows XP SP2, Access 2003 with SP3. It still doesn't work!
When installing Office 2002, and later Office 2003, I used the default installation options.
The freakish part in all this ordeal, is that the Northwind database, with all its code, is running perfect. No errors.

This all doesn't make a lot of sense to me. I'm this close to saying tough luck and giving up on this. I can't think of anything i may be doing wrong. I mean, does access requires any other components installed?
I can only hope some of you may have some idea what can be done.
If i can't use this database on my laptop, a month's work will go down the drain. Any help would be greatly appreciated.

A.
 
If this is happening with new files have you tried using a different computer with the same file. This would distinguish whether its a problem with the software or with the files. The error message doesn't really explain much:(
 
Hi,

do you have anything embedded into your database? isnt OLE in inserted object like word document or image? if so, try removing the object and the see if the problem persists.

i would have though that if the northwind works problem free, then your access is ok as i dont believe applications are picky on what it wants to open so i guess the problem is your db. have look and let us know.
in the meantime.......

if found this on a quick search http://support.microsoft.com/kb/q295824/
and a quick search is here http://www.google.co.uk/search?hl=e...g+with+the+OLE+server+or+ActiveX+control&meta=


regs,

Nigel
 
Thank you, Nigel and Swill for your replies.
I'm still pretty shocked, but i managed to solve this one. Seems it was all down to regional and language settings. They did not match between my desktop and laptop. Once i fixed it, it works perfectly!
Thanks goes to "Spy" from Utter Access forums for suggesting this very unlikely (to me, anyway) cause.
 

Users who are viewing this thread

Back
Top Bottom