Office SP3 installed and references in MDE file lost - please help!

[Kathie]

I have an application that I distribute as an MDE file that clients
run within Access. One of my clients has Win2000 and Office 2000 and
recently installed Office SP3. Now they are getting VBA errors which
I am certain stem from lost references. I only know how to get into
the reference selector in an MDB file. How can I advise the client to
fix the references on their machine? FYI, I told them to create a
blank database and recheck the references within that DB, thinking it
would carry over to my app, but they say it still doesn't work.
Thanks so much in advance!

[Jon Ole Hedne]

A mde-file does not contain any source-code, just compiled code. So the
vba-code in your mde-file has to be compiled with the correct references.
That means: You have to generate a new MDE-file which supports the
references in your clients office-installation. No workaround for that, as
far as I know...
Jon Ole Hedne

"Kathie" <gg***********@spamgourmet.com> wrote in message
news:d3*************************@posting.google.co m...

I have an application that I distribute as an MDE file that clients
run within Access. One of my clients has Win2000 and Office 2000 and
recently installed Office SP3. Now they are getting VBA errors which
I am certain stem from lost references. I only know how to get into
the reference selector in an MDB file. How can I advise the client to
fix the references on their machine? FYI, I told them to create a
blank database and recheck the references within that DB, thinking it
would carry over to my app, but they say it still doesn't work.
Thanks so much in advance!

[Allen Browne]

If we are talking about the standard Office references for VBA, Access, DAO
or ADO, they may be able to:
1. Search for the location of the files.
2. Re-register them at the command line, e.g:
regsvr32 "c:\program files\common files\microsoft shared\dao\dao360.dll"

Details of the default references and file locations for different version
of Access:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Kathie" <gg***********@spamgourmet.com> wrote in message
news:d3*************************@posting.google.co m...

I have an application that I distribute as an MDE file that clients
run within Access. One of my clients has Win2000 and Office 2000 and
recently installed Office SP3. Now they are getting VBA errors which
I am certain stem from lost references. I only know how to get into
the reference selector in an MDB file. How can I advise the client to
fix the references on their machine? FYI, I told them to create a
blank database and recheck the references within that DB, thinking it
would carry over to my app, but they say it still doesn't work.
Thanks so much in advance!