Solved

Publishing existing Access to Sharepoint

Posted on 2013-01-14
3
791 Views
Last Modified: 2013-01-14
I have a user with an existing Access database. We need to publish this database to our SharePoint 2010 but the Publish to Access Services option is greyed out. I assume this is because it was created as a regular database and not a web database. What do I need to do now? Is there a way to convert it or it would be better to do it from scratch as a web database?
0
Comment
Question by:MisUszatek
  • 2
3 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 400 total points
Comment Utility
<< I assume this is because it was created as a regular database and not a web database>>

 That is correct.

<<What do I need to do now? Is there a way to convert it or it would be better to do it from scratch as a web database? >>

  It will not convert as is.  THere is a compaitbility checker that you can run to see what in the database won't work.  

But honestly, if you have anything more then straight forms and nothing more then CRUD (Create, Read, Update, and Delete) functions, then you'll be better off to start from scratch.

Web databases are severly restricited in what you can do with them; limited forms and controls and NO VBA.  Macro's is it and list of macros that you can use are not that extensive.

  Your really should think of desktop and web Access databases as two different things.

 If you need the database to work as is, you can:

1. Use something like www.eqldata.com

2. Run it on a terminal services server and have them remote into that.

If you truely need app with a lot of functionaility I would not look to Access at this time.

Jim.
0
 

Author Closing Comment

by:MisUszatek
Comment Utility
Great answer! Thanks!
0
 
LVL 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
BTW, here's a link to a Mocrosoft Blog that discusses the compatibilty checker:

http://blogs.office.com/b/microsoft-access/archive/2009/12/21/access-2010-web-compatibly-checker.aspx

Jim.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now