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"
redpoppyAsked:
Who is Participating?
 
moduloCommented:
PAQed with points refunded (200)

modulo
Community Support Moderator
0
 
stevbeCommented:
I think it is a permission issue where you do not have permission to the location and / or account.
Is the mailbox on an exchange server?
0
 
redpoppyAuthor Commented:
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"?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
stevbeCommented:
If you logon to a remote PC can you see the Outlook folder you are sharing?
0
 
redpoppyAuthor Commented:
I can see it and acces it through "Outlook Folders".
0
 
stevbeCommented:
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?
0
 
redpoppyAuthor Commented:
From a remote I can create a new table linking to a mailbox folder listed in "Outlook Folders".
0
 
stevbeCommented:
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("MyLinkedOutlookFolderTable").RefreshLink

Steve

0
 
redpoppyAuthor Commented:
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?
0
 
stevbeCommented:
sounds OK ... are they all linking to the same Outlook folder? ... disturbing but perhaps it is caching something that is not showing.
0
 
redpoppyAuthor Commented:
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
0
 
redpoppyAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.