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.
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.
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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
