error 283806

Question

when i open ms access than  

the expression before insert you entered as the event property the following error: a probelm occurred while wholesale 2010 was communicating with the ole server

Visual Basic for Applications (VBA) encountered a problem while attempting to access a property or method. The problem may be one of the following:

A reference is missing.

For help restoring missing references, see the Microsoft Knowledge Base article 283806.

An Expression is misspelled.

Check all expressions used in event properties for correct spelling.

A user-defined function is declared as a sub or as a private function in a module.

Expressions can resolve a user-defined function only if the function is declared as one of the following:

A public function in a module

A public or private function in a code module of the current form or report

Security in Access is set to Medium or High and the Microsoft Jet 4.0 SP8 update is not installed.

A more recent verion of Jet 4.0 must be installed for Access to function properly when security is set to Medium or High. To obtain the latest version of Microsoft Jet, go to Windows Update.

now what i do ?

Answer 1

This can be caused by missing references, among other things. To check for missing references on your  development machine, open the .accdb file, then open the VBA Editor and click Tools > References. If any are marked as MISSING, you must fix those (i.e. install the libraries, re-make the references, etc).

If you are deploying this to a different machine, then you have to make sure your references are available on that machine. If you've used anything other than the standard Access references, you'll have to check that.

This can also be caused by corruption. To fix that, first make a copy of your database, then do this:

1. Compact your database
2. Compile your code - from the VBA Editor click Debug - Compile. Continue doing this until the Compile menuitem is disabled.
3. Compact again

Sometimes it helps to decompile your code. To do that, create a shortcut with this as the Target:

"full path to msaccess.exe" /decompile

Run that, then open your database. Access will decompile it. After that, run the 3 steps again.

Also be sure all machines are fully up to date with Windows and Office.