Master McNeish.

>If you look in the database container, which copy of ID.dbf is it pointing to?

Are you talking about the DBC on the server? If so, it all works fine.

It calls the newid() from the local (C) drive and updates OK. The problem is on the workstation, there is no DBC or ID table. When we call New() it tries to look on it's local drive for ID.dbf. If we put an ID.dbf on the workstation then it finds it, but our ID's are messed up and we get the "Another User" error when we try to save the record to the server table (Dup Id's).

Our MetaDbc on the workstation is pointing to the mapped drive to the server and we are looking at the data on the server from the workstation. It's just the newid() is not working.

I know this doesn't make sense because all the New() does is an APPEND BLANK. So NewID() should still be looking at the same Id table, whether called from a local EXE or from a workstation.