Do you mean the code was loaded and executed or you mean that he downloaded the file ? "I am a liar." Is this statement true or false ?

That depends entirely on your server. What are you connecting to? A file share?, TCP port?, a server application that your wrote?, NTP service?, Web Service?, ... RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Well I also had to do such a project, but the other way around, I had to put data from the client (MS Access) into the SQL server. I coded everything in vba in MSAccess. In my situation that code connects to the server, loops through all rows in my source table, and does an insert on the sql server. If you need VBA code examples please let me know.

In case you dont know, dont ask programming question here (The Lounge). You will get all kinds of answers and you probably will have a "bad ideia" of us all. We will be hapy to help, but only if you ask in the programming foruns. :-D This is the place for bull#$## talk that we love so much. :-D

You need to add the primary key colums in to the SELECT statement in order for the command builder to generate an UPDATE statement. If you don't do that then it won't know what row to UPDATE. My: Blog | Photos | Next SQL Presentation WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Toasty0 wrote: if(PostingForum==Lounge) Got My 5 :laugh:;P It is Illogical to define an inventor by his invention