I am working on (VB.NET)application which transfer table from Access db to SQL Server
Process is

Open Database read schema and copy table (from access)---> if error in reading tables throw exception ----> write table in SQL Server

Problem
when it throws exception process terminated and but it has to be like if error in reading table throw exception and move to next table

copy table from access---> if error in reading (throw exception and move to next table ) --> write table in SQL Server

any idea please
Thanks
Ayaz

hi there...

there should be a problem with how is your code write.. if you have all the process inside one try catch then it will fail after first error... so you have to structure your code to isolate every posible try catch...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========

thanks