What happens whey you try to edit the data in these
tables - any error messages etc? How are you editing
them - using Enterprise manager? (If so you must move off
the line for the edit to be committed).
Regards,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi Paul,
Manage to find the problem. An index was missing from the table which
prohibited MS Access from updating a row.
Howevere I was always able to edit a row using MS Query Analyser
Thanks
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:2b2201c49ee7$e565e230$a301280a@.phx.gbl...
> What happens whey you try to edit the data in these
> tables - any error messages etc? How are you editing
> them - using Enterprise manager? (If so you must move off
> the line for the edit to be committed).
> Regards,
> Paul Ibison
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
Monday, March 12, 2012
Non replicated tables and MS Access
Labels:
access,
database,
editingthem,
enterprise,
error,
manager,
messages,
microsoft,
mysql,
oracle,
replicated,
server,
sql,
tables,
thesetables,
whey
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment