Copying all tables in db, but one, by default.

[avivit]

I have a local microsoft access database (working copy)that holds some tables and
a copy on the server (for users).
We make the changes on our local db, and copy all the db
to the server (over the old db).

Is it possible that when copying the db, that a certain table in the db
wouldn't be able to be copied by default?
I'd like a certain table to stay on server as is, but it can't be a
read-only table, for it is changed by users (only) when using the site(asp).
I don't want the programmers to change the data in the table by mistake, but only
if we choose to (password or something?).

Buttom line - I'd like to copy all tables but one, by default,
and copy it only if we choose to (once in a life time), while the
table in the db on the server, can't be a read-only table.
Hope I'm clear.

Anyone pls?
Thanks

 

[moonlight]

One solution would be to put the single table in a database by itself and link it into your application, that way you can copy the whole of your working databse without copying the table you dont want copied.

Hope this helps

 

[avivit]

moonlight thanks. What do you mean by linking?
Will I have the same table in 2 db? That's what u mean?
Is it possible to use a macro, or use VB, in order to (on exiting the application) automatic copying the tables I want to another database?
This can help me to other purpose as well:
Is it possible to automatically create a copy of my database (as is), in a certain directory? Just using VB, or macro?
If so, that how?
Thanks much anyway.