Hello . This is a known problem.
VB and MS Access uses a special way to access the ODBC. I
think it called jetbase or something.
 
This routine can only write at tables with unique index so you
have to create a local index at the PC .
 
Hope this helps.
 
Hans Fohrman
HP Sweden