Modifying Access application

[Rattlesnake]

hi,
I have created an Access 97 application that is being implemented in an organisation. Now they have asked me to do some modifications in the application . While I do the modifications, the unmodified application will continue to be used in the organisation. When I finish the modification how do i bring the tables in the modified application upto date with the one being used in the organisation. (there are around 25 tables used).
Thanks

 

[edtab]

By the sound of it, you are working with an "unsplit" database where all your db objects (tables, queries, forms, etc.) reside in the same database.

After you have finished your modifications, copy your "modified" database in a directory different from the one where your old database resides.

Follow the following procedure:

- Delete all the tables in your newly modified database.
- "Link" all tables from the "original" database into your "new" database.

If you do this correctly, your new database would now be connected to the "live" tables containing up-to-date data.

You would now use the new database instead of the original one.

As far as the old database is concerned, you need to delete all objects except the tables.

Follow the above and you would now have effectively split up your database into the "front end" and the "back end", which is the normal way things should be.

The front end contains everything except the tables, while the backend contains nothing but the tables.

That's about it.


edtab