Solved

Linking Tables in Replicated Database on LAN

Posted on 2004-10-29
292 Views
Last Modified: 2008-02-01
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
Question by:redpoppy
    12 Comments
     
    LVL 39

    Expert Comment

    by:stevbe
    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
     

    Author Comment

    by:redpoppy
    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
     
    LVL 39

    Expert Comment

    by:stevbe
    If you logon to a remote PC can you see the Outlook folder you are sharing?
    0
     

    Author Comment

    by:redpoppy
    I can see it and acces it through "Outlook Folders".
    0
     
    LVL 39

    Expert Comment

    by:stevbe
    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
     

    Author Comment

    by:redpoppy
    From a remote I can create a new table linking to a mailbox folder listed in "Outlook Folders".
    0
     
    LVL 39

    Expert Comment

    by:stevbe
    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
     

    Author Comment

    by:redpoppy
    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
     
    LVL 39

    Expert Comment

    by:stevbe
    sounds OK ... are they all linking to the same Outlook folder? ... disturbing but perhaps it is caching something that is not showing.
    0
     

    Author Comment

    by:redpoppy
    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
     

    Author Comment

    by:redpoppy
    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
     

    Accepted Solution

    by:
    PAQed with points refunded (200)

    modulo
    Community Support Moderator
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…

    846 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    5 Experts available now in Live!

    Get 1:1 Help Now