Adding new tables to a split database

[Bobk]

I have a project that has a split database. I normally make a copy of the
live back end and use it to test modifications to forms and reports, then
load the modified front end on the live workstations. I have in the past
manually modified tables or added small tables to the back end, as necessary,
only after shutting everyone out and backing up the live data. Note - I said
manually modified the live tables. The mods have been minor with no problems.

I now need to add three new tables consisting of a lot of data fields. I
have added them to my test back end and everything is working ok. Is there an
easy way to add these tables to the live back end, such as directly copying
them to the back end or do they have to be manually entered? If they can be
directly copied, what is the procedure? Can anyone give me some advice on
this?

 

[Peter Hibbs]

Have a look at :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE Update Utility.mdb'

Peter Hibbs.

 

[Albert D. Kallal]

what I do is simply open up the back end, and then go file->get external
data...and brows to your "development" back end..and import the tables....

Really, no worse, or more work then adding a new field to an existing
table...

So, you just open up the production back end...and import the tables.....

 

[Bobk]

Thanks! I suspected you could do that but I wasn't sure. I appreciate the
confirmation.

 

[Bobk]

An after thought - can you use this technique for the front end as well? I'm
thinking Queries, Forms and Reports.

 

[Rick Brandt]

An after thought - can you use this technique for the front end as
well? I'm thinking Queries, Forms and Reports.

Yes, but it's simpler to just replace the whole file.

 

[Bobk]

I think you are right but, being able to might come in handy some time.
Thanks for the help.