OneNote compatibility with MS Access

[Louise]

Is it possible to save or link to OneNote files/folders as part of an MS
Access database?
Is it possible to insert data from MS Access database into OneNote?
An organisation in the healthcare sector has developed their own electronic
health database in MS Access and they want to be able to use OneNote on a
Tablet PC to take client notes and then access these notes through their MS
Access database.

 

[Erik Sojka (MVP)]

If the OneNote files are stored on a file server or SharePoint page, then
you could create file:// URL links within Access to point to each
individual *.ONE file.

There is an import API (details here:
http://msdn.microsoft.com/office/understanding/onenote/default.aspx ) that
was included with OneNote SP1. You or your developers would have to write
code to extract data from the Access DB and insert it into a page in
OneNote. No interoperability exists by default between OneNote and Access.

 

[Fritz Switzer]

Louise,

Is it possible to save or link to OneNote files/folders as part of an MS
Access database?
Is it possible to insert data from MS Access database into OneNote?

That is exactly what we have done.

We have released a Beta of our OneNote EMR Toolkit. It is available for
free download from the following URL:

http://www.abletfactory.com/EMRToolkit

This Beta uses an Access Database as a front-end or PMS and directly imports
into OneNote. Feel free to e-mail me if you need any additional
information.

Regards,

Fritz

 

[Chris H.]

In addition to what Erik mentioned, Louise, you may want to check the
information about usage of a Tablet PC in the healthcare industry:
http://www.microsoft.com/windowsxp/tabletpc/evaluation/bymarket/healthcare/default.mspx
There a several case studies.

Additionally, you may want to contact Tablet PC MVP Fritz Switzer of the
ablet Factory (www.abletfactory.com) who has been deeply involved with the
healthcare industry for several years. He currently has a really nifty beta
on the EMR Toolkit, which works directly with OneNote, and has developed a
lot of Tablet Medical Reference applications, including Special Interest
Dictionaries (SPIDs), HIPAA forms, etc.

Contact him through the email address on his web site, I'm sure he'd be most
happy to assist you in whatever capacity he can.
--
Chris H.
Microsoft Windows MVP/Tablet PC
Tablet Creations - http://nicecreations.us/
Associate Expert
Expert Zone -

 

[Chris H.]

Oops. I didn't notice you'd already responded.
--
Chris H.
Microsoft Windows MVP/Tablet PC
Tablet Creations - http://nicecreations.us/
Associate Expert
Expert Zone -