copying & pasting records

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

Guest

Does anyone know how to copy records from a database saved on my hard drive,
and paste them to the same database saved on my server?!
 
You can do it manually by selecting the records to be copied, copy them,
select the last (new) row in your server's database table and paste them. If
you want to do this automatically, you could make a table link from your
server's database to your local database table. Then, from you server
database you can query those local records and add them to your table using
an add query.

If this is not a one time action, then the question is, why do you need to
do this. Maybe an alternate db design would solve the problem.
 
In the database on your machine you can select the table and then go to FILE
EXPORT and then make sure the MDB file type is selected and then browse to
Click to expand...
your MDB file on the server. You can then choose which objects to send over.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
Hmmm...Thank you for your response, but I'm not sure if that will work.

What we have going on is we are creating a "Trip Report" database for our
traveling salesmen. Before they leave on a trip they will be copying the
"master" database from the server on to their individual lap top hard drives.
While they are all out on their individual trips they will each be adding
records to the database saved on their lap tops. When they return to the
office we want to have all of them copy the records they created in the
field, to the "master" database saved on our server! If one guy exports his
database to the server, when the next guy exports his, won't all the new
files from the first guy be lost and overwritten by the second guys database?
 
You should then do as Doug Steele has suggested and look into using
replication. However, a BIG caveat here is make sure that the database is
split into a frontend/backend and that the BACKEND is the only part using
replication. The frontend should reside as a copy on each user's machine.

Using replication with anything but data (tables only) leaves a high risk
for corruption.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
Thank you all for your suggestions.

We are using Access 2003 and we are all newbies (self teaching)! We did
figure out how to do it manually, so if worse comes to worse, we can do it
that way.

I was hoping there might be a way I could add a "copy" button and a "paste"
button to the form that would copy the record on the laptop database, then go
to the server database and paste it there.
 
Back
Top