trouble copying in access, will not copy all records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

number of individuals working on the same db. I am having touble copying all
of the data into one datasheet. all the records do not copy
 
number of individuals working on the same db. I am having touble copying all
of the data into one datasheet. all the records do not copy
Click to expand...

Kathy, you can see your database, and you know what you're doing.

We don't.

Please give us a little bit of help here??? How are you doing the
"copying", and from where?

John W. Vinson[MVP]
 
I have made copies of db for others. they are adding to it. I am trying to
copy from the copy of the db and pasting to the master. but I am having
trouble. I do have the autonumber on if that makes a difference.
 
MDB is obsolete; it is too buggy to be useful.

Call us when you lose the training wheels

Access Data Projects allow you to work with a real db backend; where
you can run a trace and see what's really going on

-Aaron
ADP Nationalist
 
MDB is obsolete; it is too buggy to be useful.

Call us when you lose the training wheels

Access Data Projects allow you to work with a real db backend; where
you can run a trace and see what's really going on

-Aaron
ADP Nationalist
 
MDB is obsolete; it is too buggy to be useful.

Call us when you lose the training wheels

Access Data Projects allow you to work with a real db backend; where
you can run a trace and see what's really going on

-Aaron
ADP Nationalist
 
I have made copies of db for others. they are adding to it. I am trying to
copy from the copy of the db and pasting to the master. but I am having
trouble. I do have the autonumber on if that makes a difference.
Click to expand...

Well, then don't DO it that way!!!

If two users have their own, independent, unconnected databases, then
each user will be adding new records with new Autonumber values to
their own copy of the table. Fred will put in autonumber value 125 for
data X, Janet will put in autonumber value 125 for data Y, Hassan will
put in autonumber value 125 for data Z - and when you try to copy and
paste (which is a BAD way to manage Access data) you'll get conflicts.

Instead, use a "split" database arrangement, with one single shared
"backend" database containing only the Tables, and give each user
their own copy of a "frontend" containing the Forms, Reports, Queries
and so on. See http://www.granite.ab.ca/access/splitapp.htm for a
discussion and instructions on how to set this up.

John W. Vinson[MVP]
 
split -GAG-

use a real CLIENT SERVER product like Access Data Projects.

if Access were P2P it would be outright sexy; but as it is, it is
nothing but P2NULL-- Peer to nothing

you can't run it across a network with decent performance or stability

or PEER TO NOTHING

databases aren't meant to be silos
keep them together on one farm; and use your data again and again and
again.

MDB leads to a unmanageable mess!

no performance, no security, no re-use.. no ****ING RI


MDB is for babies

-Aaron
 
Back
Top