merging databases

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Merging databases

Merging databases

resolvedResolved · Urgent Priority · Version 2003

Sammie has attended:
Access Intermediate course
Access Advanced course

Merging databases

My colleagues have updated different versions of our contact database. Is there any way of combining the most recents entries they've made into one version? There aren't any overlap contacts so hopefully it's possible.
Many thanks!
Sammie

RE: Merging databases

Hi Sammie

Thank you for your question

Could you clarify the following for me please

1. Is the contact data that you wish to transfer stored in a single table, with additional tables storing data on other subjects (e.g Companies?)

2. What is the nature of the contact table's primary key field. Is it an autonumber?

Thanks

Stephen

RE: Merging databases

Thanks for your reply.

1. The contact data is in one table but it does link to other tables eg. company table, employee table etc.

2. The primary key is indeed an autonumber.


 

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips


Server loaded in 0.1 secs.