versions

  • Thread starter Thread starter Kev
  • Start date Start date
K

Kev

Hi;


I have created an access database for recording flight
sequences and hours for my sqn. It uses several forms
and a couple of tables etc. I have sent this to other
squadrons as well. Once I fix some errors on my working
copy, how do I update the other squadron's copies.
currently they must cut and past their tables into the
new version. Is there an easier way to migrate to a new
version?

Cheers

Kev
 
Your best bet would be to split your database into two separate databases.
The backend would only contain the tables, the frontend would contain the
linked tables, queries, forms etc and be copied to each user's machine.
Send them just the frontend with instructions on how to relink the tables to
their current database location.

Before they try relinking and deleting stress for them to make a copy and
store it in a safe place. Once they've linked successfully, they can delete
all the queries, forms and reports in that database. Their new 'back-end'
should reside on a server.

Having the database split into two enables you to make endless changes to
the frontend without affecting the data in their backend.

If you want to read up more on this, search help for 'Splitting a Database'
or search Microsoft's Knowledge Base.
 
Back
Top