update db from web

[Stephen Green]

We have an Access membership database on our website that is updated
directly with changes.

We have the same database in our office that has various queries that we've
developed for offline use. These queries are NOT in the online copy.

If we simply publish or FTP the database down to our local machine it will
overwrite everything with the online copy.

How can we update the membership data in our local copy without overwriting
these queries?

Thanks.

Stephen

 

[MacDermott]

Rename your local copy.
FTP your database down from the web.
Open your local copy.
Delete all the tables.
Replace them with links to the copy you've ftp'ed down.
Now all your queries will run against the data from the web.
You can FTP a new copy down and replace that data, without affecting the
queries in the renamed database.

HTH
- Turtle