Can't work this out - Probably VBA related errors

[corpuschristi]

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.

 

[Swillsy]

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

 

[NigelShaw]

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

 

[corpuschristi]

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.