Yes all small data sets 30MB it seems that is the breaking point. I have tried using both get and mget, automated and manual to recieve the files...there is...

Any fresh ideas?

Keep it rolling....

It does help, the user is running update queries again with out any errors. Thanks for the help everyone! I wouldn't have been able to figure that out...

Thanks Earl! I'm not running the query through IIS, It is being manually run in Access. Almost all of the documentation of this error online is regarding IIS...

I have more full permissions to the directory that the .mdb resides in. I have tried running the update query with the .mdb in numerous places with all rights...

For all of the tables yes, but some of the linked views do not have their keys defined.

Thanks!

Just rebuilding the link did not work, however when I rebuilt and selected a unique key it did seem to work in one example. I will test more and...

The file is NOT read-only.

Thanks for the help!

I have full rights on the file and I'm also a DBO on the SQL Table with a DSN using NT Auth. I don't believe that rights are the...

Routes seem to be the same from both SQL box's to the Unix box.

Thank you for all the help guys....keep the ideas coming. I appriciate all your time.

To the top.

I just updated the linked tables...Unfortunately that did not help at all.

Thank you guys very much for your suggestions...please keep them coming!

Thanks :: MATT

Putting a primary key on the table didn't work and there is only 1 simple table being updated.

Still no luck...seems like the ftp fails when it reaches the larger files of the job.

HELP!