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 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
AymanDasaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
AymanDasaAuthor Commented:
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
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

AymanDasaAuthor Commented:
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

0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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?
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
AymanDasaAuthor Commented:
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.
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
AymanDasaAuthor Commented:
I open blank database and i cheack the references pliz see attachment
00231.PNG
0
AymanDasaAuthor Commented:
VOALLLLLA


its only add arabic sitting see attachment

LSMConsulting



0000.PNG
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.