Paste button disabled in Access 2007 form

[Confused&Wondering]

Hi,

I have an Access 2007 database split into a front-end and back-end. I have
been using this database successfully for some time now and have been
creating and editing records easily. But, when I try to copy and paste text
into fields on my forms the paste button is disabled. The same problem
occurs if I try to open one of my linked tables and copy and paste text in
the datasheet view of the table. However, if I create a new, non-linked
table in my database I can easily copy and paste text in that table's fields.
So why can't I copy and paste into linked tables and their forms?

Thanks for your time,
Adam.

 

[Jeanette Cunningham]

Has the paste button always been disabled in this database?
Usually, the paste button is only disabled when there is not any control to
paste into - such as when all controls on a form are locked or readonly.

This leads me to think that there is something wrong with the links to the
backend.
Apart from pasting, can you add a new record to one of the linked tables?


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia