importing data from tables

  • Thread starter Thread starter evelyn
  • Start date Start date
E

evelyn

I have a database that I have distributed to other
people. I need to modify the database from time to time.
At the moment the other people who have my database send
the whole database on disk to me, I then insert the data
from the tables into the modified database and send it
back to them.
What is the best way to get my clients to update the
latest version with their data themselves. bearing in
mind that my clients do not have assess skills and I am
not showing all the menu bars on their versions. Even if
i give them the menu bars or tell them to hold the shift
key when opening, the tables are linked, so importing the
tables with the same names deletes the links.
 
The usual way to handle this is to split the single .mdb file into a Back
End (Tables only) and a Front End (everything else plus linked tables to the
BE.)

This way you can make all the changes you want to queries, forms, reports,
and code without affecting them in any way. Just send them the new FE and
have them overwrite their old one (or back it up first in case they want to
"rollback".)

If you have to make changes to the tables themselves then it is trickier. (I
try hard to avoid this at all.)

Ideas include your current process of shutting them down while you make
changes.
Alternatively you may be able to wirte code to make the changes "on the
fly".
The 2nd option is riskier in case something goes wrong, they won't know how
to fix it.
 
Back
Top