Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Tue Jun 22 10:43:01 CDT 2004
Holy cow...turns out I wasn't insane after all!!! (at least regarding this problem;)) M$ issued a hotfix to address my EXACT situation. http://support.microsoft.com/default.aspx?scid=kb;en-us;841365 Microsoft Knowledge Base Article - 841365 Description of the Access 2002 post-Service Pack 3 hotfix package: May 27, 2004 The following issue is fixed in this hotfix package, but was not previously documented in a Microsoft Knowledge Base article: When you try to import a file such as a Microsoft Excel spreadsheet in Access 2002, you cannot rename a field in the Import Wizard. This issue may occur after you install Microsoft Office XP Service Pack 3 (SP3). Mark -----Original Message----- From: Mitsules, Mark Sent: Monday, June 21, 2004 3:37 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Method 'Columns' of object 'IImexGrid' failed 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com