Link to home
Start Free TrialLog in
Avatar of AymanDasa
AymanDasaFlag for Saudi Arabia

asked on

Error Massage whin I open this access file MDE File

i receive this error when I open the file in attachment in access 2003 in Government Relation Officer  PC (GRO) but i can open without any problem in my PC both PC is windows XP sp2 and Microsoft office 2003


Note:
*.   I cannot upload MDE file to https://www.experts-exchange.com so ...
*..  plz before open the file just change the extinction  from mdb to mde
*... Sorry for Arabic language but that the stander in Government inside KSA  


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 (http://office.microsoft.com/en-us/default.aspx).
* 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 (http://windowsupdate.microsoft.com/).




GRO.mdb
0002.bmp
0003.bmp
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

You have a problem with your References, and uploading your file here won't help. You must determine what Reference is missing ... to do this, open the .mdb file (hold the Shift key down to bypass the startup items), then open the VBA EDitor, then click Tools - References. If any are marked MISSING, then you'll need to fix them. Post back here what you find.
Avatar of AymanDasa

ASKER

Thanks LSMConsulting but first you should rename the file to  GRO.mde


i press shift as you say so i can access to menu but

I can't Open References  its disabled  ( see attach )


sorry I am beginner in Access and VBA
0004.bmp
This is an .mde file ... you'll need the .mdb file to determine what references you require on the target machine. Downloading this won't help me at all ... you'll have to find the .mdb that.
I receive the file from government just like this . I cannot ask them any more file because its open in my PC.

but  I can open the file in my PC foe the same time I cannot open in GRO Office??

what is the missing in his PC ????????????


HELP ME LSMConsulting

The references in this database are as such:

VBIDE
stdole
DAO
Access
VBA

I'm not sure what version of Access is referenced, but otherwise these are standard references, with the exception of the VBIDE reference ... there is little need to have this reference unless you're building a developer's utility that must interact with the VBA editor.

So at this point it would be something on the GRO Office computer that is missing ... or something that is not correctly installed (like Access). Have you tried to open this on another machine?
Note also this could be the result of corruption, although I'd not think so since you can open the file on your machine. If it is, there's little you can do about it since this an MDE file.
VBIDE
stdole
DAO
Access
VBA

what I should do to all this references ..

how to add references to mde file ?

the same file is working in my PC.
These are the references that are currently set in your MDE file. You don't need to do anything to these, nor can you. An .mde file is a compiled file, and you cannot make changes to it.

I'd suspect that your GRO machine has an older version of one or more of these references. What version of Access is the GRO machine running? Access can upgrade references (i.e. change a ref from Access 9.0 to Access 10.0) but cannot downgrade them.
I open blank database and i cheack the references pliz see attachment
00231.PNG
ASKER CERTIFIED SOLUTION
Avatar of AymanDasa
AymanDasa
Flag of Saudi Arabia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks ... I enjoy wasting my time for 0 points, and hope that you have great luck with future questions ... I'll not answer any more of them.