Merging tables/data in MSAccess

[drblackard]

I am building a members database for our church. Everything is going fine. Now I want to know how I can update/merge new updates to the database without deleting the information that others have already put into it. Example: Pastor may have added 25 new member information tables, I have a new update for the form of MSAccess database and a new look for the login, is there anyway that I can just build a backup/upgrade module to just update that form or login form without loosing any information in the database. I guess I could just export the form to a disk and import it to the new database but I would like for it to be professional, looks mean everything. Thanks in advance.

 

[Lilliabeth]

Hi drblackard,

The first thing that concerns me is that the Pastor might add 25 tables. New members should become new records, not new tables. Either you said it wrong, or you have major problems with your design.

The second thing is you can split your database into a back-end and front-end. The back-end has the tables. When you need to make changes to forms and reports, you change out the front-end and the data is unaffected.

 

[drblackard]

I said it wrong...you're right. when added members it is the records...I am stressed and trying to figure this out...Sorry and thanks for the correction.

Front-End and Back-end sounds good and where can I get this from. I don't know too much about front-end and back-end splitting. Is this pretty easy? Thanks

 

[TheAceMan1]

How are ya drblackard . . .

At your leisure be sure to go over & understand the following (the heart & soul of any DB).

Fundamentals of Relational Database Design

Normalizing Tables

Table Relationships

See Ya! . . . . . .

 

[Lilliabeth]

It is easy. Look in Help for split database.

You will likely want to put the back end on a network share, and put a copy of the front end on each user's computer.