Version Difference

[Guest]

I have a database used by several users. The version of Access are
11.6566.8107 & 11.6566.8122. Does anyone know what changed between those two
versions. I have ODBC calls failing in version 11.6566.8122. The error
message is very unhelpful!

 

[Jeff Boyce]

Richard

The error message may give us some clues (we may have seen the error, even
if it is uninformative)...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,
Can't paste in a screen shot but it reads "OBDC-connection to
'AZBLS_on_MILLC3' failed.".
We've checked the ODBC connection. We have 5 folks using this database
from a public drive. I had to insure everyone had the same ODBC connections
as my own. The only differnce I can find with the one having trouble is the
version difference...

 

[Jeff Boyce]

Are you using a DSN to connect? Have you tried creating a new DSN on that
one PC and re-connecting/linking all the tables?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,
Sorry it took so long to respond. Super busy. Yes once the DB was ready
to test I helped each person create the DSN entries both in Windows XP and
our Oracle client. 3 of us are on one version and it works. two are on a
slightly newer version and the ODBC calls fail.

So as a work around I developed a MS Word template the others would fill
out and I would take it from there. I wrote a routine to process the data
from the MS Word document object. But my new problem is my call to -
On Error Resume Next ' Defer error handling.
Set Pptr = GetObject(, "Word.Application")

Fails. I get the message - "ActiveX component can't creat Object".
Additionally the ON ERROR RESUME NEXT doesn't seem to work because the code
to check err.number never executes. I have tried all 4 of the acceptable
classes for MS Word to no avail. I.E.

To create this object Use one of these identifiers:

Application Word.Application
Document Word.Document, Word.Template
Global Word.Global

I've tried lookig at the library references but none that I have tried have
helped.

I really appreciate your willingness to discuss these things. It's great
to be able to bounce ideas/problems off someone...

 

[Jeff Boyce]

Richard

I wish I had more ideas for you. Perhaps one of the other readers has run
across this.

Have you tried searching on-line?

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP