MS Access to SQL Server 2K -data transmission

• s_saran2k

  Valued Member

  Points: 67

  More actions

  April 22, 2008 at 6:32 am

  #71153

  Hi,

  I have to include error handler to handle error when a data transmission happening from a MS access database to MS Sqlserver 2K DB.

  I want to have the retrying option like in vb(on error resume).

  when an error happens and error logging for some specific type of

  errors (say, for primary key errors)

  any sugesstions..

  Thanks in advance

  saran

• Jorge.G

  SSC Enthusiast

  Points: 192

  More actions

  April 24, 2008 at 4:24 pm

  #806929

  What method are you using to transfer the data?

  In what direction are you operating?

  Who controls the transfer ?Access or Sql Server?