Solved

access on the server - will outlook work for individuals?

Posted on 2004-08-23
5
227 Views
Last Modified: 2010-04-08
i have created an access database and it is going on a server.
It uses microsoft outlook and it includes this line of code when creating an email

    Set myolapp = CreateObject("Outlook.Application")
   
i just wanted to check - for each individual, it will open and use their own outlook on thier pc - with their own address.

is this correct?
if there is a microsoft outlook on the server as well, will this mess that up? will it then default to using the servers microsoft outlook?

thanks
0
Comment
Question by:swill2003
[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
  • 2
  • 2
5 Comments
 
LVL 18

Expert Comment

by:Karen Falandays
ID: 11876828
Hi swill, don't know of any application that has done this before. The BEST thing you can do is test it with several users.

Tell me more about what it is the application needs to do with Outlook. Is this for one corporation, or a generic app?

Also, most corporations have many Outlook servers. Most users open Outlook first thing in the am and leave it open all day. WIll this launch a new version of Outlook?

Test, test, test
Good luck
Karen
0
 

Author Comment

by:swill2003
ID: 11879592
well i have set up a database that does the same thing as the new one, in respect to outlook.

Say you do a search on a company... the company details appear and there is a button that when pressed, opens up a new message in outlook and puts the email address into the To: space, it also puts in the subject. The first database i created for one company is put on the server and works fine with each individual. The thing is i have created a database for another company but they didnt have the space for me to work there so i did it at the same office as i created the last one. it works fine here and i am about to take the database to the new company and suddenly thought - maybe all servers are different?! and maybe it wont work the same.
if it works ok on the system i am working on now do u think it is likely that it will work ok on the new system?
well actually.... the first company - i put the database on the server drive X:\ . is that the same as putting it on the server?
or is that just putting it on a drive?
oh im confused now lol

i am 19 and know what i have been taught and know wot i have learnt myself but i havent really thought about the different systems!
0
 
LVL 18

Accepted Solution

by:
Karen Falandays earned 125 total points
ID: 11879645
Sounds like you are doing just great swill! Yes, X drive is considered server, and each company uses a different letter name for the "home" drive. I thinks you should stick to what you have and explain to new company that it is ready for them to test on their system, even if they won't let you test. Explain that they may need to tweak it to work on their system. Alos, just put a reference to the database using a generic universal naming convention (UNC) instead of using the X drive name, and all will be OK
Best of luck
Karen
0
 

Author Comment

by:swill2003
ID: 11879679
thank you karen :)

could you explain what you mean by putting a reference to the database using UNC,

0
 
LVL 2

Expert Comment

by:zonaltech
ID: 11905435
\\SERVERNAME\SHARENAME\

X: is MyShare on MyServer, X:\Thisdir\ = \\MyServer\MyShare\ThisDir\

UNC = The direct path to the server share, without drive mapping.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Many people use more than one email account and so it becomes difficult for them to manage them when they use separate accounts,  so, in this article, I have shared an easy way to add Other Mail Accounts in your Google Inbox. It helps to combine all…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Viewers will learn the different options available in the Backstage view in Excel 2013.

718 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