MS Access 2010 Web Application with SQL server

[Sanyusha]

Hello!

I have a question about creating web application in Access 2010.
I want to use tables from SQL server 2008 (like .adp format).

Can I do it? I create a "web database" project and import tables from SQL server but I can't see these tables in the browser after publishing application on internet...

 

[boblarson]

A web app in Access 2010 REQUIRES SharePoint 2010 in order to use the web capabilities. You can't just use it with SQL Server and have it be a web app.

 

[Banana]

Indeed. They did want to support externally linked tables but at this point, they could not do so within the deadline so that will be in the next version. So for now, we have to use SharePoint lists only.

Also you were able to add linked tables to a web database because this is to support hybrid application - mixing of web and client objects. Say you have ten forms and you only need 5 of them to be available on web browser. Instead of creating two Access file, you can just use same file ("web database" that is) then the other 5 forms will be available only when you open it in Access and thus can use VBA & externally linked tables.

HTH.

 

[Sanyusha]

Boblarson and Banana: Thank you for answers!

Now I have another question!.. Can you please advise me a development tool for SQL - based web application?

 

[boblarson]

Can you please advise me a development tool for SQL - based web application?

Well, I can think of ASP.NET, PHP or Python.

 

[Learn2010]

To Banana
Do you think they will have the next release that will allow you to send a database to the web without SharePoint?

 

[Banana]

I'd hope so. I know that they wanted to support Business Data Connectivity (which is basically SharePoint's ODBC) and thus enable external lists (a la Access' linked tables) but they couldn't do so in the timeframe so had to hold back on that for 2010. However, Clint Covington has posted on Access team blog several months that this is a shortcoming they hope to address.

If nothing else, I would encourage you (and any others) to email Access team (you can do so by going to their blog and clicking the contact form there) and tell them that you really want support for different data sources with web databases. I know you're not alone, and I figure that it's better to at least email them so they can be sure that it's a popular request and thus worth pushing for it.

 

[Learn2010]

Thanks for your timely reply.