open outlook saved email from access

My user is saving emails from outlook and putting the location and name into a Microsoft sql database. They want to have a tool created in access that will open the saved file when needed.  Is there a way to do this?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
With no details on how this is being done., is difficult to say...
Saving emails how exactly?
If the emails are in Outlook originally, ...what the need to "save" them anywhere else?
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
can you show as sample data what was saved in MS SQL and how you want to do this in Access? is the data in MS SQL was linked/ imported into Access? Do you need an interface to open the saved file? where and how those files are being saved?
kw66722Author Commented:
1. saving the email to a server.
2. taking the location and name of file and saving that in a nvchar field in  the database
For example: "C:\user\xx\zzzz.msg"
3. in Access opening the email when a person clicks on the field

Unless there is a better way to do this.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
ok, so at the end, you need the part of a Click event in Access to launch a .msg file?
Jeffrey CoachmanMIS LiasonCommented:
Still confused...
In a typical environment, Emails are stored on an Exchange "Server", I still don't see a need to store the emails a second time...

It is still not clear exactly how you are doing this...
kw66722Author Commented:
A click event in access would work. Is that possible?
Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
do you think you could reply to Jeffrey on his comment at: ID: 41067564 ?

we try to understand your issue with further details
kw66722Author Commented:
I discovered the hyperlink and was able to open the file. The reason I was storing it at a separate location is because there is no other way for me to link to the email from the sql table. The other fields in the table are relevant for the stored email.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
...oh, never mentioned external SQL tables or fields...

Glad you got it working, can now accept your own post as the solution
kw66722Author Commented:
I figured it out on my own.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.