Strange problem with libraries

A

Anne

I downloaded a client's access database (access 2002) to my computer to make
some changes. I have Access 2002 on my computer and use it to load this
particular database. But I only have Access 2002 loaded, no other Office
2002 product.
After I send the database back to the client, I have to change the Excel
library from Excel11 to Excel10, because they only have office 2002 on the
server, i.e. missing Excel11 library.
Only this time it is not letting me change it, I keep getting the error
message: Error loading .dll. Even after browsing to the existing excel.exe I
keep getting the same message.
Does anyone have a clue what could be happening here?
Anne
 
A

Anne

I did not make it clear that I do use Office 2003 , which naturally has the
Excel11 library.
I have Access 2002 on my computer, just for this client. Everytime before,
when I had to make changes to that database, after I put the database back
onto the client's server, I would just go to the libraries and change from
Excel11 to Excel10. But now it refuses to accept the change.
Anne
 
A

Anne

I just found the answer in the Microsoft knowledgebase. It will also resolve
similar problems I have on computers having other version of Office than I
have.
I just created on the clients computer the same directories for microsoft
office that my computer has, which is C:\Program Files\Microsoft
Office2003\Office11
I transferred my office2003 excel.exe into that directory on their computer.
It works, I was expecting it no to work, but I had to try.
I think this even falls within the license agreement with Microsoft, since I
am allowed to have a copy of my Microsoft Office on a server, where I
exclusively work.
Anne
 
T

Tony Toews

Anne said:
I downloaded a client's access database (access 2002) to my computer to make
some changes. I have Access 2002 on my computer and use it to load this
particular database. But I only have Access 2002 loaded, no other Office
2002 product.
After I send the database back to the client, I have to change the Excel
library from Excel11 to Excel10, because they only have office 2002 on the
server, i.e. missing Excel11 library.
Only this time it is not letting me change it, I keep getting the error
message: Error loading .dll. Even after browsing to the existing excel.exe I
keep getting the same message.
Click to expand...

Use Late Binding instead of the Excel reference.

Late binding means you can safely remove the reference and only have
an error when the app executes lines of code in question. Rather than
erroring out while starting up the app and not allowing the users in
the app at all. Or when hitting a mid, left or trim function call.

You'll want to install the reference if you are programming or
debugging and want to use the object intellisense while in the VBA
editor. Then,. once your app is running smoothly, remove the
reference and setup the late binding statements.

Sample code:
' Declare an object variable to hold the object
' reference. Dim as Object causes late binding.
Dim objWordDoc As Object
Set objWordDoc = CreateObject(" Word.Document")

For more information including additional text and some detailed links
see the "Late Binding in Microsoft Access" page at
http://www.granite.ab.ca/access/latebinding.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top