Is there a "CopyRecord"?

[Gordon Jones]

I have been trying to find a "CopyRecord" command with no
success. I would like to synchronize my development
directory's .mdb data with that in an operational
version. To do this, the only efficient way I have at
present is to programatically empty out the development
tables, then Export/Import from the operational version,
which is time consuming. I'd rather be able to access the
operational tables, and do a record-by-record copy/paste.
Does anyone have any suggestions?

Gordon

 

[Glen Appleton]

Hi Gordon,

Try using a combination of append and update queries to synchronize the two
tables. I've used this in a few applications and it's fairly efficient. Of
course, if the table is not in use and your doing a batch update, you may
want to take a look at the TransferDatabase method of the DoCmd object.

Hope this helps,
- Glen

 

[Gordon Jones]

Hi, Glen,

Thanks a million. You had just the right solution

I had already programmed a couple of routines to empty out
the tables I want to update, and it took me about an hour
to put together the Append queries to copy the tables from
my updating tables in a production version of the db and
append them to the development db.

For the benefit of anyone else with this need, I empty
them from inaccessible functions in the development code.
The Append queries are in a special copy of the production
version that is linked to the production back-end mdb.

Gordon