I know this is poor practice but I wanted to append 3 records of data to a SQL table. I have a link to that table in MS Access 2000. I open up the table in Access , scroll to the end, and paste the 3 records into the table. Immediatly the results of that process are 3 lines of #DELETED# until I refrexh the table ( close then re-open). My question is why does it do this as I expect to see the new record immediatly after I have pasted them?
Any help/ explanation would be greatly appreciatedDoes the table have a primary key?
Rand
This posting is provided "as is" with no warranties and confers no rights.
No comments:
Post a Comment