Adding rows to Access/SQL table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dmacpherson - 31 Mar 2006 04:24 GMT

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 ?

Reply to this Message

Sylvain Lafontaine - 31 Mar 2006 05:03 GMT

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?

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

> 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 ?

Reply to this Message

dmacpherson - 31 Mar 2006 06:02 GMT

>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?
[quoted text clipped - 4 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

Reply to this Message