Copying a column/field

[Guest]

From a novice Query user,
I have a db with 64000 records.
When I try to do a copy and paste of info from one column/field to another I get the following message after 6408 files have been copied :
File sharing lock count exceeded. Edit MaxLocksPerFile registry entry.

Can anyone tell me why this happened,
what is the MaxLocksPerFile registry and
how do I change it?

Or is there a better way to copy my data from one field into another?
Thanks.

 

[Steve Schapel]

Zirkerc,

Copy/paste is not really a very satisfactory approach when dealing with
database data. It sounds like this is a job for an Update Query...
though it is a very unusual thing to want to duplicate data from one
field to another, especially within the same table. Or if it is between
tables, probably an Append Query would be the way to go. Maybe you
could give some more details about what you are trying to achieve, if
you need more specific help.

 

[Guest]

More info..
I have a column named Classified which contains a persons initials and a date
Instead I want 2 columns - 1 with the initials and 1 with the date classified
What I was trying to do was copy the Classified column into a new column, then I was going to find and replace the data not required
I would GLADLY take any advice on a different or more Access-like way of completing this task

THANKS

----- Steve Schapel wrote: ----

Zirkerc

Copy/paste is not really a very satisfactory approach when dealing with
database data. It sounds like this is a job for an Update Query...
though it is a very unusual thing to want to duplicate data from one
field to another, especially within the same table. Or if it is between
tables, probably an Append Query would be the way to go. Maybe you
could give some more details about what you are trying to achieve, if
you need more specific help

 

[Steve Schapel]

Zirkerc,

Thanks for the further information. Yes, it sounds like an Update Query
would be the way to go. The specifics of this would depend on the
details of the data, in particular whether there is a reliable way of
identifying the division between the two data elements. For example, if
the initials are always together, and there is a space or some other
character between the initials and the date. ANyway, you just update
one field to the initials portion of the existing data, and the other to
the date portion. I you need more precise help, please post back with
details of the existing data, with examples.