SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Viewer for MS Access 2010 Web Database


Viewer for MS Access 2010 Web Database

Author
Message
RTaylor2208
RTaylor2208
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2519 Visits: 1262
Hi,

Does anyone know if there is a MSAcess viewer (runtime) that can be used to open a Web database?

I know it can be done with a regular MS Access database but so far I can't get it to work with a web database and I don't have a sharepoint server that I can publish it to.

This is just to demo a POC to a customer before the back end is created in SQL server and the front end developed as a website.

MCITP SQL 2005, MCSA SQL 2012
WendellB
WendellB
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2028 Visits: 1830
It is possible to view what is called a "hybrid" web database using SQL Azure using an Access front-end, so you could try using the 2013 runtime in that mode. But if you are running SQL Server on a web server, then Access isn't a very satisfactory tool. If you want to pursue the SQL Azure approach, post back.

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
RTaylor2208
RTaylor2208
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2519 Visits: 1262
At the moment no SQL server development has been done a d if they agree with the POC we will then pursue creating the entire database within the customers data centre and utilise there existing infrastructure for the front ends. Azure will not be used in this case.

The access db was put together quickly to demonstrate the rough feel of the app.

Ill need to look into the runtime you mention. Basically I am trying to save just performing a demo via webex or equivalent and letting the client play with the POC.

MCITP SQL 2005, MCSA SQL 2012
WendellB
WendellB
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2028 Visits: 1830
We've done a number of demos of that type using either remote desktop or LogMeIn using Access and actually let them play with the prototype and make suggestions, and it worked pretty well. We had a single PC dedicated to that sort of thing. One of the challenges in your case is to make the Access prototype have the look and feel of a web app - it's very easy to implement functions in Access that are either very difficult or impossible to implement in a web app.

Wendell
Colorado, USA

Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
RTaylor2208
RTaylor2208
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2519 Visits: 1262
Giving them access to a hosted VM may be an option as we will not allow any sort of remote access into our network due to some of the sensitive projects we have.

The forms are pretty basic so far in terms of functionality, if they want to go ahead all reporting will be SSRS reports, the only reason for MSAccess at this stage is the development time to create the DB and visual interface is significantly less than the equivalent POC in SQL sever with a java or c# front end.

I have been looking into the ms hosted sharepoint option as its very cost effective solution to publish the db on the web but time consuming to setup the sharepoint server. But once done we can use it to share other POC's.

MCITP SQL 2005, MCSA SQL 2012
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search