Microsoft Office Access 2007 - Database

Question

Hi there

I having this situation.

I have this database, and I often change his data.

However, sometimes I want to update it when I receive a new version of the same database. But I don't want to lose the previous data.

Is there some way that this situation can be done? If yes, how? If no, do you know any similar situations that can help me?

Thanks in advance

Diogo Água

Answer 1

First make sure you keep a fresh copy of the 'new database.'

Open the new database and link all of the tables of the old database.

Run an append query from linked table to the new database tables.

Answer 2

If I understood it right, the new version would contain data because it would come from a different person, not me, so it would have new data.

I am satisfied, thank you =)

Answer 3

Sorry, i didn't understand the meaning of"be populated".

Could you rephrase it, please?

Answer 4

I'm working with Access 07 and Sharepoint 10, and a database linked between them.

For example, lets suppose that I'm working with and database,

DBExampleV1.0.db

Client    Project

AB 1

CD 2

EF 3

And get it linked with Sharepoint 10, that's fine so far.

I change some things in my database in sharepoint

Client    Project

AB 2

CD 2

EF 2

So far, so good.

But I receive a new version of this database, DBExampleV1.1.db, with new information.

Client    Project  Country

AB 1  Russia

CD 2  Brasil

EF 3        EUA

FE 4        Japan

But I want to keep the old data, not to erase it!

If it is possible, do something like:

----- Example 1 ------------------------------------------------------------------

Client    Project Country

AB 2

CD 2

EF 2

AB 1  Russia

CD 2  Brasil

EF 3        EUA

FE 4        Japan

----- Example 2 ----- ------------------------------------------------------------------

Client    Project Country

AB 2

CD 2

EF 2

AB 1  Russia

CD 2  Brasil

EF 3        EUA

FE 4        Japan

----- Example 3 ----- ------------------------------------------------------------------

Client    Project  

AB 2  Russia

CD 2  Brasil

EF 2        EUA

FE 4        Japan

That's my question.

Btw, if I not answer right away is because I am busy, I haven't forgot this question and I will give my feedback as soon as I understand of to do this.

Thanks in advance

Diogo Água

Answer 5

You need to explain this in greater detail. Why would you receive a "new version"? How do you receive new data? How do you change the data (by queries or data entry)?