How to read outlook inbox that's located on another computer(the server)?

[cursedeye]

I've created a ACCESS database and upsized to sql server. Users run it from a mapped net drive, basically a shared folder. In this way users can access to this program without getting on the server, mainly because of safety issue.

In my program, Access and Outlook are connected. It can read/send emails in Access, but it only reads the email in your current OS, which is fine when you are in the server, because it reads the server's outlook account. When I was designing it, I was building it in the server so I was fine... however, when you are accessing it on your laptop via a shared folder, it reads your OWN outlook account under your currently OS instead of the server's.


This is a piece of the code that I'm using

Set Inbox = OlApp.GetNamespace("Mapi").GetDefaultFolder(olFolderInbox)

It only reads the default inbox of your currently OS, so the default inbox could be whatever… it all depends on where you run it...


Is there any way to modify that (or other alternatives) so it will only read the emails in the server's outlook account instead of your own when you run it from a mapped net drive？



Thanks in advance! I'm sorry for my broken English..

 

[darbid]

Users run it from a mapped net drive, basically a shared folder.

I am not an expert but I think you should try to get the .mdb file onto a users local computer. I think you will have problems if people are sharing the same file on a shared drive.

it can read/send emails in Access, but it only reads the email in your current OS, which is fine when you are in the server, because it reads the server's outlook account. When I was designing it, I was building it in the server so I was fine... however, when you are accessing it on your laptop via a shared folder, it reads your OWN outlook account under your currently OS instead of the server's.

Outlook is built that way otherwise anyone could read everyones emails and even worse send emails as someone else. Once again I am not an expert with Exchange server but do you have this running?

The only way you are going to get what you want is that on the server you need to share this email with read and write permissions.

Then you will be able to use "GetDefaultSharedFolder" method to get the default folders of the servers email.

I am not 100% sure but you might have to add this server mailbox to each users outlook. Maybe your code will work without this step, I am not sure.

To send an email it is a little easier. You just use the .sendonbehalfof and set this to the server email address.

The second "option" I think - if you do not have exchange server is that you need to add a second account to each users Outlook. Then you need to use this. If this is what you need to use then we can look at how.