Adding rows to Access/SQL table

  • Thread starter Thread starter dmacpherson via AccessMonster.com
  • Start date Start date
D

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 ?
 
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?
 
Sylvain said:
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
 
Back
Top