#deleted in access, but the record is in SQL

  • Thread starter Thread starter Stewart Saathoff
  • Start date Start date
S

Stewart Saathoff

Hello everyone,

I have come across an interesting issue. Whenever I add records to an
access database in a datasheet subform, I receive #deleted when I enter
back
into the form. The records do however exist in the SQL database. I found
this kb article on the subject and it tells me to download the newest Jet
Service Pack. I tried that, but it does not seem to work because I have
Windows XP SP2 on my machine. Can anyone help?

I have also noticed that I am unable to update the records after they are
created...

Thanks

http://support.microsoft.com/default.aspx?kbid=291546
 
-----Original Message-----


Hello everyone,

I have come across an interesting issue. Whenever I add records to an
access database in a datasheet subform, I receive #deleted when I enter
back
into the form. The records do however exist in the SQL database. I found
this kb article on the subject and it tells me to download the newest Jet
Service Pack. I tried that, but it does not seem to work because I have
Windows XP SP2 on my machine. Can anyone help?

I have also noticed that I am unable to update the records after they are
created...
Click to expand...

My clients had a similar problem last week. We installed
Office SP3 on their machines and the error disappeared.

HTH,
 
I have Office 2003 with all of the updates installed. Any suggestions?
Does anyone at Microsoft monitor this board?
 
Back
Top