[AccessD] Access Database on Web

Jim Lawrence accessd at shaw.ca
Wed Jan 2 13:02:53 CST 2013


Hi Guys:

If the number of options and databases available ever get confusing check
out the following graphs and these should answer all your questions. ;-)

http://gigaom2.files.wordpress.com/2012/12/databaselandscape.jpg

...and...

http://gigaom2.files.wordpress.com/2012/12/olderdblandscape.jpg

The over-view article is:
http://gigaom.com/cloud/confused-by-the-glut-of-new-databases-heres-a-map-fo
r-you/

I have been working with ancient Informix for the last little while and even
some MS Access. One of the subjects that would also be interesting would be
to follow which DB forked from another. I.E. MariaDB forked from MySQL, MS
SQL decended from Sybase or MS Access morphed from Foxbase. There are no
Databases that did not spawn from a previous progenitor and whether the
offspring are better is always debatable.

Jim  


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Wednesday, January 02, 2013 12:33 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access Database on Web

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 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list