Solved

Publishing existing Access to Sharepoint

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Report that will show table changes 7 48
format date field on certain entries 8 30
Access 2010 Query Syntax 5 25
Running Total in Access 4 20
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
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.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

864 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

22 Experts available now in Live!

Get 1:1 Help Now