Sharing data between remote users.

[highandwild]

I have a split Access 2003 database, FE/ BE, with two users who never meet each other using the database on their laptop but for different purposes.

Each user has a different table, tbl_Members and tbl_Transactions, that the other person needs to update on their database on a monthly basis for member maintenence and transaction logging.

The only way in which they can send data to each other is by email.

The users are not very computer literate so the process needs to be made as easy as possible.

I realise that there are many ways in which this can be done but what way is to be recommended as the best?

Any ideas?

Thanks

 

[dkinley]

Here is an idea that I incorporated once into a system. The users didn't need a formal journal entries so I created a simple method so that users of different shifts could 'post each other notes'.

I created memo and yes/no fields for each relevant section of the system whereas they could post the notes about the subject at hand. To mark a note as new they simply added to memo field and checked a checkbox located near the text control on the form.

I had a subform on the main screen that was fed a query driven by the checkbox complete with the high-level ID. The screen also had which relevant section had a new note so the user could drill down and act on the note.

In this manner, the user's didn't need a formal passdown (except for super high priorities).

HTH,
-dK