2. Move the Transfers.mdb file to a network drive.You might find that this common folder uses different drive letter mappings on each machine. It might be H:\common\ on Linda's machine and i:\common\ on Virginia's machine.

3. On both machines,go to the VB Editor and under Tools, References,add a reference to ActiveX Data Objects 2.1 Library (or higher).

4. In both their applications,find an out-of-the-way cell to store the path to transfers.mdb.Name this cell TPath.

5. Whenever the application needs to read or write data from the tblTransfer table, use the code shown in the rest of this chapter.

0 0

Post a comment