Version Difference

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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
 
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... :-)
 
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
 
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...
 
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
 
Back
Top