Hello,
We have created a simple database in order to managed a small team working on a help desk.
A critical way this operates is by having a mail enabled public folder in exchange. When we create the linked table in the Access Database for one user the linked table pulls in the mail items and we are able to view the items in a form view to carry out actions without issues.
We have a problem though when this database is shared and opened by another user, as the linked table is static to the user it was setup with. A second user receives and error referring to MAPI information not available. I know why this is as when i look at the Linked table manager i see the local path to a temp file on the originals users PC.
Is there a way i can create the linked table to the exchange public folder in a way that allows us to share the database with multiple users? Does the linked table manager have to link through Outlook or can it be done in the back ground with stored credentials?
Many thanks in advance.
Olstar
We have created a simple database in order to managed a small team working on a help desk.
A critical way this operates is by having a mail enabled public folder in exchange. When we create the linked table in the Access Database for one user the linked table pulls in the mail items and we are able to view the items in a form view to carry out actions without issues.
We have a problem though when this database is shared and opened by another user, as the linked table is static to the user it was setup with. A second user receives and error referring to MAPI information not available. I know why this is as when i look at the Linked table manager i see the local path to a temp file on the originals users PC.
Is there a way i can create the linked table to the exchange public folder in a way that allows us to share the database with multiple users? Does the linked table manager have to link through Outlook or can it be done in the back ground with stored credentials?
Many thanks in advance.
Olstar