An Unhandled win32 exception occurred in MSAccess.exe

[Alice Liu]

Hi,

I am importing a database from DB2 to Access but prompted by the error from Visual Studio Just-in-time Debugger with the error of "An unhandled win32 exception occurred in MSAccess.exe" and asked to Send Error Report to Microsoft from the dianlog box "Access has encountered a problem and needs to close".

I went to web site searching for the solution and some of them said if the PC installed SQL server 2005 will be generated the error of this.



My PC used be able to import the database from DB2 before installing the SQL server client instance. Would that be the problem? How can I work around this problem and still be able to import DB2 database to Access? any help would appreciate.

[NTC]

import refers to the import of table data only. no other code.

attempt to export data out of db2 to an intermediate neutral file such as excel, delimited txt.

then perform your import of that table data on that file.

note that db2 permits much wider tables than does Access2003 which is limited to 2k character width records. you may need to split tables into acceptable widths before import and then link together.

hope this helps.

[Alice Liu]

Hi NTC,

Thank you for the help.

I have very basic skills of db2, would you please show me how to commend this batch?

Thanks.
Alice