Solved

Publishing existing Access to Sharepoint

Posted on 2013-01-14
3
828 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

786 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