#deleted in access, but the record is in SQL

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
 
S

Stewart Saathoff

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#deleted in access, but the record is in SQL 1
Access FE, SQL BE, Some tables, won't let me edit (or delete) my records! 0
Linked Table Cant Delete Record 2
Can't delete datasheet subform record in Access 2007? 0
Q.) Jet DB error: Multiple Users able to write to MS Access DBsimutaneously? 3
Access frontend SQL backend - error 1
Share problem with Access to SQL 2005 table 5
Linked Table to SQL Server / Unable to add records 0

Top