Export / Import Linked Tables

[deadzed]

A group of managers and myself all use a Microsoft Access database to quickly assign different individuals to different teams depending on which requirements are required for different circumstances. Each team consist of 4 groups of 6 individuals each.
I have 3 seperate tables linked by their autonumbered IDs.

Team Name
TeamNameID (autonumber)

Group Name
GroupNameID (autonumber)
TeamNameID

Individual Name
IndividualNameID (autonumber)
GroupNameID

TeamNameID linked to TeamNameID in Group Name
GroupNameID linked to GroupNameID in Individual Name

What I would like to be able to do is to create a routine that allows each of the managers to export their Team template to a delimited text file, which can then be emailed to the other managers who will then be able to import the Team templates into their own database copies. This will allow the managers to share their templates without the other managers having to manually duplicate their effors.

I am running into a problem with the autonumber fields though. If someone has created templates and then appended the downloaded Team template, the autonumbered fields don't match the linked values in the other tables.

Any ideas how I could make this operate correctly?

 

[ProgramError]

Hi dead zed

Sounds as though you have four different databases running on four different machines which aren't linked in any way. Is this the case?

What you need to do is have four separate front ends and one back end with a table containing all the fields and only one auto number. One of the fields could contain the group number, so if you ran a query on that group number then your results would show only that groups information but it would be relative to all the other information contained in the table and therefore you could manipulate the informaton as a whole and not as separate information in separate databases.




Ian Mayor (UK)
Program Error
Programmers do it one finger at a time!

 

[deadzed]

Thanks for the reply. Yes, this would definately be the way to go if all users were connected. I have created a few of this type at my primary job. However, we are located in various areas across the nation and I don't have nearly the skills required to develop an online database. That's why I was wanting to create the export/import routine.

 

[deadzed]

Could anyone tell me if it's even possible to export/import linked tables with autonumbered fields and have them line up correctly in the imported database?