redpoppy
asked on
Linking Tables in Replicated Database on LAN
I have a replicated database running on a LAN (Windows XP, Office 2003). On the home PC I have linked a table containing customers enquiry form e-mails from a mailbox on Outlook, I then pick out the data via a query and load it into a form. Is there a way to link this table/mailbox to a remote computer running the same d/b ? At the moment if I try to access this table from a remote, I get a "run-time error '3710' - MAPI folder or address book not found"
ASKER
Thanks for replying, stevebe. No the mailbox is not on an exchange server. We are using "Outlook Folders" to share the mailbox across the LAN, so I'm not sure if this is confusing the issue. From what I understand, it's not possible to share the mailbox across the LAN without using MS Exchange Server or something like "Outlook Folders"?
If you logon to a remote PC can you see the Outlook folder you are sharing?
ASKER
I can see it and acces it through "Outlook Folders".
Trying to hunt down any permissions issues ... If you are on the remote PC can you make a new table that links to the folder?
ASKER
From a remote I can create a new table linking to a mailbox folder listed in "Outlook Folders".
ok ... perhaps the conneciton needs to be refreshed before using ... not being familair with shered outlook folders I could not say I *know* this to be an issue but it is worth a try ...
CurrentDb.TableDefs("MyLin
Steve
CurrentDb.TableDefs("MyLin
Steve
ASKER
Hi Steve,
Gave your suggestion a try but still the same error. I'm thinking now I know I can make a new table on the remote PC, I could come up with a work around by having a separate table and query for each machine in the network (eg: "Query/TableName" & "ComputerName") and then setting the form's recordsource accordingly - what do you think?
Gave your suggestion a try but still the same error. I'm thinking now I know I can make a new table on the remote PC, I could come up with a work around by having a separate table and query for each machine in the network (eg: "Query/TableName" & "ComputerName") and then setting the form's recordsource accordingly - what do you think?
sounds OK ... are they all linking to the same Outlook folder? ... disturbing but perhaps it is caching something that is not showing.
ASKER
Yes, they will all link to the same folder on the main PC. I'm going to try it out over the next day or so and I'll let you know. Thanks for your help. Steve
ASKER
Ok, I seem to have come up wth a solution. I set up a table linked to the mailbox on the main computer for each of the computers in the network (eg: TblEnq_Comp1, TblEnq_Comp2 etc where Comp1, Comp2 is the computer name), plus a temporary table common to all (eg: TblEnq) containing the req'd data.
When the user wants to view an enquiry, I have a form displaying TblEnq data, with a button that executes a refresh of the linked data as follows:
1) A delete query to remove all data from TblEnq
2) An append query that requeries the mailbox info into TblEnq_Comp(n) and then re-loads TblEnq
Seems to work so far, thanks again for your help. Steve
When the user wants to view an enquiry, I have a form displaying TblEnq data, with a button that executes a refresh of the linked data as follows:
1) A delete query to remove all data from TblEnq
2) An append query that requeries the mailbox info into TblEnq_Comp(n) and then re-loads TblEnq
Seems to work so far, thanks again for your help. Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Is the mailbox on an exchange server?