Access Error

[elsanto]

Howdy boys and girls,

It's been a little while since I've been on, and I've missed you all more than you can know! But I'm back with a brand new problem.
Actually, it's a reoccuring problem. I finish building a db from scratch, put in the finishing touches, and when I click, for example, a command button on the main menu form that is supposed to open another form, I get this error:

"The expression On Click you entered as the event property setting produced the following error: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
- The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
- There may have been an error evaluating the function, event, or macro."

End of story. I can't use any of the command buttons in my database, making the thing almost useless. All macros and codes are fine, I haven't changed anything. it's almost as if the db corrupts.

Any ideas on how to fix this?
Cheers.

 

[namliam]

Try opening a module and compiling it. This will highlight any coding problems you have in your VBA, enabling you to correct the problem(s).

Regards

The Mailman

P.S. I think that XP (and 2000) compile all VBA at once and 97 and 2.0 compile only your current module. If i am right I hope your working with XP (or 2000) otherwise its gonna be a pain. But its your sollution.

 

[elsanto]

Mailman,

I tried compiling the module earlier. No luck. I get another error message:
"Error accessing file. Network connection may have been lost."
I get this elsewhere in the db as well.
This has really got me beat, and is causing no end of frustration. Nothing worse than finishing a db and having it fall apart.
(*!#$&)_)@$#!??!!!?!!!
Any other ideas?

 

[namliam]

Try repairing it.

If that failes you might try DeCompiling the entire DB (never needed to do that myself but it appeares to be some all involving thing (Be sure to backup!! before attempting this)

Find something on this forum or on www.accessvba.com about Decompiling. Mind you IT IS A LAST RESORT!

Regards

 

[elsanto]

From the errors I'm getting, I'm thinking it isn't a vba thing. Could it have something to do with the installation or setup of Access? The error about problems communicating with the OLE server have me wondering...

 

[Rich]

It's one of the newly introduced bugs, search here for Network Connection

 

[elsanto]

Rich,
Is that for real?

 

[elsanto]

And if so, is it fixed in Access 2002???

 

[Nero]

As Rich said this is a bug.
You will need to download a patch then copy all your code and paste it as a text file.
Then set each form to HasModule = No
Then you will need to create a new Db and import your tables, forms etc.
Finally copy/paste back the code you saved as a text file.

As far as I'm aware this is the only solution.
I will try and dig out the patch for you.

 

[Nero]

The download you need is the 'Microsoft Office SP3'.
This will prevent it from happening again.

 

[elsanto]

Many thanks. Am downloading it now.

I'm running Access 2000, but I have a colleague who isn't using her copy of 2002. If this bug is ironed out in 2002, I thought I'd swap versions with her. What do you think?

 

[Nero]

When this error occured for me I had Access2k and XP installed at the same time.
I'm not sure if XP version will iron it out as it didn't for me.