Adding rows to Access/SQL table

[dmacpherson via AccessMonster.com]

Access 2003 SQL 2000 Win 2000
In Access I added new rows directly into the linked table which resides on an
SQL back-end. When clicking on the table in Access the new rows are visible,
however, when I view the table in SQL Enterprise Mgr they are not added to
the table. Updating existing rows works fine. I tried relinking the tables...
no change. The only way I can sync the data is to delete the linked tbl in
Access and Get External Data/Link Tables again. Is there a commit function
somewhere I have overlooked ?

 

[Sylvain Lafontaine]

MDB or ADP? Only a single row at a time or multiples rows? Did you took
the precaution of refreshing the data in SQL Enterprise Manager?

 

[dmacpherson via AccessMonster.com]

MDB or ADP? Only a single row at a time or multiples rows? Did you took
the precaution of refreshing the data in SQL Enterprise Manager?

Access 2003 SQL 2000 Win 2000
In Access I added new rows directly into the linked table which resides on

[quoted text clipped - 7 lines]

Access and Get External Data/Link Tables again. Is there a commit function
somewhere I have overlooked ?

MDB , multiple rows, I did not refresh data