[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Linking Tables in Replicated Database on LAN

Posted on 2004-10-29
13
Medium Priority
?
299 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
Comment
Question by:redpoppy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
13 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 12447003
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
ID: 12448703
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
ID: 12451445
If you logon to a remote PC can you see the Outlook folder you are sharing?
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

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

Expert Comment

by:stevbe
ID: 12452287
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
ID: 12462205
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
ID: 12465184
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
ID: 12475086
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
ID: 12475341
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
ID: 12481664
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
ID: 12485004
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:
modulo earned 0 total points
ID: 13161879
PAQed with points refunded (200)

modulo
Community Support Moderator
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

656 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