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
Solved

Publishing existing Access to Sharepoint

Posted on 2013-01-14
3
842 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
ID: 38776554
<< 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
ID: 38776556
Great answer! Thanks!
0
 
LVL 57
ID: 38776559
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

856 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