Version differences

T

TRM

I have created a DB using Access 2002 which employs automation with Word and
document tracking. Some (MOST)of the document tracking is controlled by
actions taken in the Access database. These actions seem to work fine on my
computer, however, once on the server, which uses 2003 ONE step is not
working. Is this possibly a Version issue- seems unlikely to me, but I have
tried about all other possibilities I can think of.

If you have a suggestion, or a reference - please let me know! Thank you
for your time!
 
T

Tony Toews

TRM said:
I have created a DB using Access 2002 which employs automation with Word and
document tracking. Some (MOST)of the document tracking is controlled by
actions taken in the Access database. These actions seem to work fine on my
computer, however, once on the server, which uses 2003 ONE step is not
working. Is this possibly a Version issue- seems unlikely to me, but I have
tried about all other possibilities I can think of.
Click to expand...

What is the failing step? I suspect the problem is due to references
to Word. Which could be different on a server. When you state
server do you mean Terminal Server?

If it is due to referencing Word then you want to use Late Binding.

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