View Single Post
  #2 (permalink)  
Old October 5th, 2006, 10:53 PM
hassan2000 hassan2000 is offline
Registered User
 
Join Date: Oct 2006
Location: Cairo, Cairo, Egypt.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi
I had the same problem
It is an issue related to the OLEDB 4.0 when opening an Access MDB database with Adox to create / append a new table and the columns will have a certain ordinal.

use MSSQL instead of OLEDB to do the job with ADOX
or use ADO OpenSchema that would do a similar job
Details of both solutions and the problem are vailable in the followin link

http://support.microsoft.com/kb/299484/EN-US/

This should solve the problem

BR

Hassan