copy paste tbale without primary key

[iccsi]

I tried to copy and paste a table from database A to database B and
got records deleted message from Access.

After tring a couple of times, I open table as design mode and
realized that the table without primary key.

I just wonder that can I copy and paste a table without primary key
tables?
If not, any work around for this?


Your information is great appreciated,

 

[KARL DEWEY]

I got a little mixed up by your explaination. Maybe you could append rather
than paste.
Post sample data from TableA, TableB results, and what TableB should look
like.

 

[iccsi]

I got a little mixed up by your explaination.  Maybe you could append rather
than paste.
Post sample data from TableA, TableB results, and what TableB should look
like.
--
KARL DEWEY
Build a little - Test a little








- Show quoted text -

Thanks for the message,
Yes, append query can do the work.
Are there any document say that Access does not support copy paste
tables without primary key?

Thanks again,

 

[iccsi]

Thanks for the message,
Yes, append query can do the work.
Are there any document say that Access does not support copy paste
tables without primary key?

Thanks again,- Hide quoted text -

- Show quoted text -

I just realized that the table I am copy is Access 97 version.
After I converted to Access 2000 or after version then I am able to do
so,
It seems that MS Access 2000 and above is not compatable with Access
97 and before.

Thanks again,