updating data from web

  • Thread starter Thread starter Stephen Green
  • Start date Start date
S

Stephen Green

We have an Access on our web site. It is constantly updated directly. We'd
like to be able to update our local copy of the database, without
overwriting any new queries and reports that have been created locally in
the interim.

Is there a way to just copy the tables and have them overwrite the local
tables with the same name?

I've tried using copy and paste, but the choices Access gave me didn't seem
appropriate. I didn't see an option that would simply overwrite the
table(s) with the newer version.

Is there a way?

Thanks.

Stephen
 
Stephen,
When you say the database is on your web site, you must
mean that it is refreshed on a local network. I gather
that the whole database is put out there on a regular
basis. If so, you have several options. You could
delete your tables in your local database, and import the
new tables at each update. Go to file, get external data
import. But, the best bet may be to link the tables. If
not sure how repost. I have even linked to tables then
develop delete and append queries to refresh my local
tables. That way I do not have to worry about altering
the main network tables.
 
Back
Top