[AccessD] Access Database on Web

Gustav Brock gustav at cactus.dk
Wed Jan 2 02:33:28 CST 2013


Hi Tina

I've followed this thread loosely as I've found no easy and cheap way to
move from Access desktop apps to web based apps.

Inspired by Shamil I picked up Visual Studio at version 2005, now 2012, and
- as my son-in-law then predicted: You will never look back.
This is not an easy route but tutorials, videos, guides, and help is easy to
find as VS is so widely used. Though, of course, SQL Server is native to it,
it will work with most major database engines including MySQL - I can add
that I helped Fernando, the chief developer of the MySQL Connector, to sort
out a bug which prevented a connection to databases with the old user access
verification.

However, the database is only a part of a project and I don't quite get why
so much discussion has been about administrating it. As Doug mentioned, one
option for a case like yours is using LightSwitch. Formerly it created
SilverLight apps only, but now HTML5 has been added:

http://www.devproconnections.com/article/visualstudiolightswitch/visual-stud
io-2012-lightswitch-144815
http://blogs.msdn.com/b/lightswitch/archive/2012/09/13/visual-studio-2012-la
unch-building-business-apps-with-lightswitch-joe-binder.aspx

You will need VS 2012 Professional which you can obtain as a part of the
MAPS Developer subscription.

Hosting of LightSwitch apps is available at numerous hosting providers. Here
I have two small apps hosted at a top-notch provider at extremely low cost.
Even so, support is prompt and responsive:

http://en.unoeuro.com/

/gustav

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Stuart McLachlan
Sendt: 2. januar 2013 00:14
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] Access Database on Web

If you want avoid getting locked into a declining market, I'd go with *AMP.


MS are down to around 16-17%  market share now on web  servers,

http://news.netcraft.com/archives/2012/11/01/november-2012-web-server-survey
.html
and
http://w3techs.com/technologies/overview/web_server/all


On 1 Jan 2013 at 12:52, Doug Murphy wrote:

> Hi Tina,
> 
> If you are familiar with the Microsoft environment I'd stick with SQL 
> Server. There are many low cost web hosts, Arvixe for one, that offer 
> SQL Server databases that are more than adequate for the type of web 
> project your talking about. These companies use SQL Express but I have 
> found no performance limitations. Possibly if you're talking thousands 
> of hits per minute and gigs  of storage you might find the limits, but 
> I haven't I we have some quite challenging stored procedures running on
several of these.
> You might also take a look at Microsoft LightSwitch for your 
> development environment. The new version will publish to the desktop 
> or web in HTML 5 so the apps will work on any phone or tablet.
> 
> My 2 cents worth.
> 
> Happy New Year.
> 
> Doug 




More information about the AccessD mailing list