Mystery solved, sort of. The client's machine had a non-US regional setting. Once we set it to US English it worked fine. It appears as if an internal Access date time stamp was causing the problem, but we are not sure. In any event it is working, thanks for the help. Robert Vreeland -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Robert Vreeland Sent: Friday, August 12, 2005 16:49 To: thelist at lists.evolt.org Subject: [thelist] SQL not performing all inserts Hello List, Hope some one will have an idea, so here goes. I wrote a windows app that migrates the access databases we use in our application to ms sql databases. We have run the updater on six different machines - to update ourselves and clients, with no problem. But on our most recent attempt - another client, only partial success. The application can connect and read / write from both the access databases and the ms sql database but only inserts a few record before stopping. I'm not getting any connection errors, and we have tried the updater locally with a copy of the clients db with no problems - everything migrates. We duplicated our ms sql server config options on the client machine - including the query and connection timeout params, with no apparent difference. Ultimately, I wouldn't even care if the updater failed as we can do a manual import of the data, a pain as there are over a hundred databases involved, but the problem seems to be extending to the application itself, which is relying on at least one database to store user variable for sharing between asp and asp.net and that write seems to be failing as well. So any suggestions on where I can look for settings that might prevent lots of inserts? It seems as if something is timing out or blocking the inserts after x number. Thanks in advance for any help Robert Vreeland -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !