why can I not copy or paste anything in datasheet view?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geisi - 19 Jun 2007 15:44 GMT

i have a table open in access, in datasheet view, and i can not cut, copy or
paste in to the table or from the table. i want to copy one feild at a time.
The data is stored on a server, so when i use a diffrent computer evrything
works fine.
can someone help me?

Reply to this Message

scubadiver - 19 Jun 2007 16:01 GMT

Check the data properties for the form:

filters = yes
edits = yes
deletions = yes
additions = yes
data entry = no

For each field, the data properties:

enabled = yes
locked = no

> i have a table open in access, in datasheet view, and i can not cut, copy or
> paste in to the table or from the table. i want to copy one feild at a time.
> The data is stored on a server, so when i use a diffrent computer evrything
> works fine.
> can someone help me?

Reply to this Message

geisi - 19 Jun 2007 16:32 GMT

thanks.
where do i find these data properties?

> Check the data properties for the form:
>
[quoted text clipped - 14 lines]
> > works fine.
> > can someone help me?

Reply to this Message

Rick Brandt - 19 Jun 2007 16:38 GMT

> thanks.
> where do i find these data properties?

If you are in a table (not a form) then they don't exist. Sounds like your
link is read only. Common when the table on the server has no Priamry Key
or unique index.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

geisi - 19 Jun 2007 18:02 GMT

my file is not a read only, i can do evrything with it besided for copieng
and pasting. i can do this with this file on other computers, just not on
mine. i upgraded to a newer version of access (2003) and it did not help.

> > thanks.
> > where do i find these data properties?
>
> If you are in a table (not a form) then they don't exist. Sounds like your
> link is read only. Common when the table on the server has no Priamry Key
> or unique index.

Reply to this Message

scubadiver - 20 Jun 2007 07:50 GMT

In the design view, click on the small black square in the top left hand
corner and go to the "data" tab.

For a particular field right click, go to the properties and then go to the
"data" tab.

If you had set the form up normally these settings should be defaulted.

> thanks.
> where do i find these data properties?
[quoted text clipped - 17 lines]
> > > works fine.
> > > can someone help me?

Reply to this Message