having problem during upsizing from local access table to remote sql server

Hello !!
i have problem in upsizing data to remote sql server .
my test connectivity is ok. some time if i specifi my database which is in
remote sql server it is giving "overflow error " , if i use master data base
i am not getting any error ,but i am not getting the repote generated when sql
table is created.

i am very new to sql is there any other method i any one guite me .

i have to write a vc++ code , through which i have to update local access table
and once the access table is updated , i have to transfer all the data to remote
sql server using ip address. once the data is updated in sql server i have to delete
the data in access table .

please help me !!!
thanks in advance!!!