auto copy and paste function

[ploddinggaltn]

I've searched previously posted questions and am not finding mine, so here
goes...

I have a database with 6 tables linked to it and they are stored on the
users C Drive. I also have these tables stored on a server. My user records
records all day long and they are stored on his C drive. At the end of the
day I want him to close the database with a cmdbutton. When he clicks the
command button, I want the tables from his C drive copy and pasted to the
tables on the server. Is this possible? I've coded in in Excel before, but
just not sure how to do this in Access.

For example two of the tables are titled "tblCustomers" and "tblCases". The
location on the C drive where these file are located is C:\Documents and
Settings\JFORD\Desktop\LogDatabase_be.MDB. I'd like all my tables copied and
pasted to s:\LogDatabase\Backend\LogDatabase_be.MDB.

As always I appreciate your help, thank you

 

[Klatuu]

Why are you not just linking the user to the server database and let them
work there?
What you want to do can be done, but it is open for errors that could affect
the validity of your data.

 

[John W. Vinson]

I've searched previously posted questions and am not finding mine, so here
goes...

I have a database with 6 tables linked to it and they are stored on the
users C Drive. I also have these tables stored on a server. My user records
records all day long and they are stored on his C drive. At the end of the
day I want him to close the database with a cmdbutton. When he clicks the
command button, I want the tables from his C drive copy and pasted to the
tables on the server. Is this possible? I've coded in in Excel before, but
just not sure how to do this in Access.

For example two of the tables are titled "tblCustomers" and "tblCases". The
location on the C drive where these file are located is C:\Documents and
Settings\JFORD\Desktop\LogDatabase_be.MDB. I'd like all my tables copied and
pasted to s:\LogDatabase\Backend\LogDatabase_be.MDB.

As always I appreciate your help, thank you

As Dave says, this can be done - but it's almost surely a Bad Idea. What if
some other user is working on LogDatabase_be in the interim? Does the user
have stable, fast LAN connectivity to the backend? If so, they can be linked
to it all day, updating the "real" data; if not, then your day-end job is
going to be much harder anyway!

That said... an Append query to a linked table is the way to go. Copy and
paste is rarely appropriate in Access.

John W. Vinson [MVP]

 

[ploddinggaltn]

It's just a matter of time efficiency. The response time is faster if he
work locally due to server traffic...he is the only one that does data entry.