Publishing existing Access to Sharepoint

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?
MisUszatekAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< 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
 
MisUszatekAuthor Commented:
Great answer! Thanks!
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.