[AccessD] Method 'Columns' of object 'IImexGrid' failed

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Mon Jun 21 14:36:36 CDT 2004


Group,

This problem is slowly driving me insane:(  I am no longer getting the
subject error, however the Access Import/Link Table wizards are STILL not
behaving quite normally.  Normally, you are allowed to change field names or
mark a column as skipped.  But in my current configuration, the column
properties do not update when you click on a different column header.  So
far I have loaded the latest service pack and/or version for Windows 2000,
Office 2002, Jet 4.0, and MDAC.  Does anyone know what to try next?
Unbelievable as it may seem, our corporate IT people have given me local
admin rights...apparently with the hope that I am able to solve this problem
on my own...because they haven't been successful.

I have two thoughts on this: First...something was installed/patched out of
sequence???  Second, Jet 4.0 service pack 8 was installed, but according to
KB829558 it is for Windows XP...I am running Windows 2000.

I ran Component Checker Version 2.0 against MDAC 2.8 RTM.  It found two
mismatches:

- <group name="MISMATCH" count="2">
- <file name="ODBCBCP.DLL" dir="%SYSTEMDIR%\">
  <release name="MDAC 2.8 RTM" version="2000.85.1022.0" /> 
  <found Description="Microsoft BCP for ODBC" date="12/12/2003"
fileVersion="2000.085.1025.00 built by: (_sqlbld)" size="24576"
version="2000.85.1025.0" /> 
  <result mismatch_fields="version" /> 
  </file>
- <file name="SQLSRV32.DLL" dir="%SYSTEMDIR%\" CoreFile="Yes">
  <release name="MDAC 2.8 RTM" version="2000.85.1022.0" /> 
  <found Description="Microsoft SQL Server ODBC Driver" date="11/18/2003"
fileVersion="2000.085.1025.00 built by: (_sqlbld)" size="401408"
version="2000.85.1025.0" /> 
  <result mismatch_fields="version" /> 


Awaiting any suggestions...

Mark



-----Original Message-----
From: Mitsules, Mark 
Sent: Wednesday, June 16, 2004 9:45 AM
To: [AccessD]
Subject: [AccessD] Method 'Columns' of object 'IImexGrid' failed


Group,

Has anyone seen this error and know how to 'fix' it?

If anyone recalls, my PC was recently 'refreshed' by the IT
department...after which I was unable to import .xls files into Access.
Well they did a complete reinstall and all the different file types are now
available for import.  But now, when running either the import or link table
wizard, I get the error listed above.  Any suggestions?


Mark
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list