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 appreciated
Does the table have a primary key?
Rand
This posting is provided "as is" with no warranties and confers no rights.
Showing posts with label poor. Show all posts
Showing posts with label poor. Show all posts
Thursday, February 9, 2012
#DELETED#
I know this is poor practice but I wanted to append 3 records of data to a S
QL table. I have a link to that table in MS Access 2000. I open up the tabl
e in Access , scroll to the end, and paste the 3 records into the table. Imm
ediatly the results of that
process are 3 lines of #DELETED# until I refrexh the table ( close then re-o
pen). 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.
QL table. I have a link to that table in MS Access 2000. I open up the tabl
e in Access , scroll to the end, and paste the 3 records into the table. Imm
ediatly the results of that
process are 3 lines of #DELETED# until I refrexh the table ( close then re-o
pen). 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.
#DELETED#
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.
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.
Subscribe to:
Posts (Atom)