How can I update forms and tables in a shared Access database?

[Frank]

We have an Access database Sch_S.mdb in the shared driver S across the
network. I have a copy of that database in my local driver C, named as
Sch_C.mdb. As per users' request I added some check boxes in the main
form of the database, and added some relevant subroutines in that form.

Now I need to put the modified database Sch_C.mdb to the shared S
driver. Since new data had been added to tables (say T1, T2) in
Sch_S.mdb while I was working with Sch_C.mdb, I have to update the main
form to Sch_S.mdb, or to update data in tables T1 and T2, in
Sch_C.mdb. What is the best way to do that?

What I am thinking is the following:
1. Send a note to users to stop using this shared database Sch_S.mdb
(or open Sch_S.mdb for exclusive use, so others will not be able to use
it)
2. Delete all data in tables T1 and T2 in Sch_C.mdb, then import data
from T1, T2 in Sch_S.mdb to T1, T2 in Sch_C.mdb
3. Move Sch_S.mdb to a back up folder in shared driver S, so we can
recover the old version in case of trouble.
4. Copy Sch_C.mdb from C to S, and Change its name to Sch_S.mdb
(Actually I am using the same name Sch.mdb in C and S)

Is that way working? Is there a simpler way to do that?

Thank you very much for your help!

[Larry Daugherty]

Split your database into a Front End, with everything but the tables
and a Back End with just the tables. Using the linked table manager,
point the Front End at the Back End tables. Note that you'll have to
be careful to change the links as you install your new Front End on
the server. Once you have the split configuration going, you can make
your changes and then just install the Front End, changing links as
required. Life will get a bit more complex when your changes require
a change in the table design. When that happens you're back into the
issue of getting the data from the older format into the new format
with no one else using the database.

A further complication is that best practice dictates that each user
have a copy of the Front End on their desktop. For ideas on how to
make it all work, look on Tony Toews's site for FE Updater.

HTH
--
-Larry-
--

"Frank" <tu**@yahoo.com> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

We have an Access database Sch_S.mdb in the shared driver S across the network. I have a copy of that database in my local driver C, named as Sch_C.mdb. As per users' request I added some check boxes in the main form of the database, and added some relevant subroutines in that form.
Now I need to put the modified database Sch_C.mdb to the shared S
driver. Since new data had been added to tables (say T1, T2) in
Sch_S.mdb while I was working with Sch_C.mdb, I have to update the main form to Sch_S.mdb, or to update data in tables T1 and T2, in
Sch_C.mdb. What is the best way to do that?

What I am thinking is the following:
1. Send a note to users to stop using this shared database Sch_S.mdb
(or open Sch_S.mdb for exclusive use, so others will not be able to use it)
2. Delete all data in tables T1 and T2 in Sch_C.mdb, then import data from T1, T2 in Sch_S.mdb to T1, T2 in Sch_C.mdb
3. Move Sch_S.mdb to a back up folder in shared driver S, so we can
recover the old version in case of trouble.
4. Copy Sch_C.mdb from C to S, and Change its name to Sch_S.mdb
(Actually I am using the same name Sch.mdb in C and S)

Is that way working? Is there a simpler way to do that?

Thank you very much for your help!

[Frank]

Thank you very much for your help. I am trying to do that way...

Frank

[Albert D. Kallal]

I got some good reading on splitting here:

http://www.members.shaw.ca/AlbertKal...plit/index.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal