• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

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"
0
redpoppy
Asked:
redpoppy
  • 6
  • 5
1 Solution
 
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
 
stevbeCommented:
If you logon to a remote PC can you see the Outlook folder you are sharing?
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
moduloCommented:
PAQed with points refunded (200)

modulo
Community Support Moderator
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now