Access 2007 Runtime with Sharepoint Lists

J

JodieM

Hi,
I'm wanting to do a list in MOSS Sharepoint 2007 / Access 2007 that
uses the feature that enables access reports to be viewed from within
sharepoint by clicking on the View Menu. I have it all working well
with the Access 2007 database linked to the sharepoint list. Does
anyone know if I can do the same solution using an Access 2007 runtime
database? The rest of the users in the company don't have 2007 yet,
and as I can't install Runtime on the same PC as full Access 2007 I
can't test it.

Thanks
 
G

Guest

Have you tried starting up as a runtime version? Make a shortcut and adjust
the startup line with the /runtime option to start the database. This way you
can simulate the runtime view. Maybe you can test it if sharepoint will
accept this.

hth
 
J

JodieM

I definitely think it can't be done now. The linking of the Access
2007 database back into sharepoint will only allow an .accdb or
an .accde file extension.

But I've come up with an excellent solution to do basically exactly
the same thing with an Access 2003 database.

First step link the tables into Access 2003 as per normal, then create
queries or reports in the Access database.
Next step is to create a macro to open each query or report.
Next step is to add a content editor webpart below the document
library or list web part and add some Javascript to create a hyperlink
that opens access and then runs the macro to run the report. It works
really well.

I go the idea for this solution from here.
http://www.imakenews.com/mernstmann/e_article000435389.cfm and then
modified the Javascript to be a link rather than a button.

Here is my Javascript

<html>
<script language="javascript" type="text/javascript">
function runCmd(cmd)
{
var shell = new ActiveXObject("WScript.shell");
//alert('About to run : ' + cmd);
shell.run('"msaccess.exe" "C:\\Folder\\DBName.mdb" /x MacroName',
1);
}
</script>
<body>
<a href="javascript:void"
onclick="runCmd()">
Print Report</a><br>
</body>
</html>

So there it is, my complete replacement solution for viewing Access
2003 reports from within sharepoint.
There could be a better way, if anyone knows I would love some
feedback.
JodieM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add field to Access view of Sharepoint database 1
Integrate MS Access 2007 and SharePoint 2007 Server, Authentication and Authorization problems 5
Access 2007 and SharePoint List Links 1
MS Access 2007 and SharePoint 2007 1
schema has changed - access and sharepoint 1
Sharepoint 2007 lookup field showing up as memo in Access 2003 3
Reference for deploying Access 2007 in Sharepoint 2007 2
Observation - Sharepoint ID field vice Access Autonumber 4

Top