|
Home > Archive > MS Access project with SQL Server > March 2006 > Adding rows to Access/SQL table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Adding rows to Access/SQL table
|
|
| dmacpherson via AccessMonster.com 2006-03-31, 3:32 am |
| 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 ?
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200603/1
| |
| Sylvain Lafontaine 2006-03-31, 3:32 am |
| 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 Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"dmacpherson via webservertalk.com" <u7735@uwe> wrote in message
news:5e0ece7d21741@u
we...
> 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 ?
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200603/1
| |
| dmacpherson via AccessMonster.com 2006-03-31, 3:32 am |
| Sylvain Lafontaine wrote:[color=darkred
]
>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 - 7 lines]
MDB , multiple rows, I did not refresh data
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200603/1
|
|
|
|
|