copy paste tbale without primary key

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
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.
 
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 -
Click to expand...

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,
 
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 -
Click to expand...

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,
 
Back
Top