To all,

We found the problem. We use 5 DBC's in our app. The stored procedure NewID() is in our main DBC called MedApp. When running local, the other 4 DBC's tables found NewID() fine, but when we went to a network, NewID() was looking in the default directory. The reason was that we had USE id in the stored procedure. We replaced that with MedApp!id and it seems to work fine now.

Thanks for everyones help.