[AccessD] Help with an Access web app -- finding records without matching related records

Jim Lawrence accessd at shaw.ca
Sun May 29 10:40:33 CDT 2016


That is the point and that point is why the old Access can not move forward. Binding the Access FE, the MDB BE and its DAO connector made it an irrelevant product in the age of the internet...it was then locked to the desktop and closed networks. Microsoft could have made the product viable by just building or attaching it to a real database, by default, from the get-go. 

The first Access application I built with no MDB was in 1997 using the new MS SQL BE, little more than its Sybase beginnings and using the ADO connector but it made it one of the best databases on the market.

But that is history and there is little point dwelling on it. My only question now is why Microsoft continues to have something they can Access. To my mind, if Access is not going to be rebuilt as a JavaScript framework, just dump it and focus users on using ADO.Net and MS SQL. I am glad to see that within a year MS SQL will become a true internet Database...running on all platforms. I think that will be a big game changer. :-)

Jim

----- Original Message -----
From: "dw-murphy" <dw-murphy at cox.net>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Saturday, May 28, 2016 12:17:36 PM
Subject: Re: [AccessD] Help with an Access web	app	--	finding	records	without matching related records


    
Mdb is just a file.  Think any Windows host will allow to put on your site  and you just use ado to interact with.  Can also use ado.net.


Sent from my Verizon Wireless 4G LTE smartphone

-------- Original message --------
From: Martin Reid <mwp.reid at qub.ac.uk> 
Date: 05/28/2016  1:13 AM  (GMT-08:00) 
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com> 
Subject: Re: [AccessD] Help with an Access
 	web	app	--	finding	records	without matching related records 

Not a problem. Goggle, search,choose

Martin
________________________________
From: Jim Lawrence<mailto:accessd at shaw.ca>
Sent: ‎28/‎05/‎2016 00:15
To: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com>
Subject: Re: [AccessD] Help with an Access web app -- finding records without matching related records

The main problem is trying to find a web hosting company that will allow a MDB on their site...most deem that DB as toxic.

Jim

----- Original Message -----
From: "Jim Dettman" <jimdettman at verizon.net>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Friday, May 27, 2016 1:38:39 PM
Subject: Re: [AccessD] Help with an Access web app      --      finding records without matching related records


Access web apps.   I was referring to nothing else.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Doug Murphy
Sent: Friday, May 27, 2016 12:52 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Help with an Access web app -- finding records
without matching related records

Jim,

Not sure what your definition of a web app is but MS seems to be playing
pretty well in this environment for the Visual studio community; see Xamarin
for developing smart phone apps for Android and IOS, MVC with Angular or
React for single page apps. If you use real tools you can pretty much do
anything you want. You do have to make an investment in learning, but that
is part of paying your dues.

Doug

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Lawrence
Sent: Thursday, May 26, 2016 10:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Help with an Access web app -- finding records
without matching related records

Right now there is thousands or more accurately tens of thousands of web
apps and hundreds more being created each day. In Vancouver, alone, there
are over 5.5K companies developing web applications but they are not
Microsoft developers.

Microsoft is just starting to build a system that can create a viable web
app but they are many years behind. MS produced great desktop applications,
maybe the best, but that is not the new economy.

Jim

----- Original Message -----
From: "Susan Harkins" <ssharkins at gmail.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, May 23, 2016 4:14:28 AM
Subject: Re: [AccessD] Help with an Access web app -- finding   records
without matching related records

Actually...

If the 365 sub with SharePoint catches on, I can see Access web apps being
very useful. I'm already planning my next Salato app.

As MS moves toward more mobile app support and collecting data in the field,
I can see Access Web apps filling a collection and viewing niche.  And, it's
certainly easier to use -- a few hours and you've working. That's a long way
from Access desktop. I realize there are other technologies, but Access Web
apps is easy.

I don't think MS is doing a good job on pr.

Susan H.


Susan,

 You will find the number of people using web apps to be very few and far
between.

 Microsoft has been taking a stab at web apps since 2007.  2010 was a
refinement of 2007.

 2013 was a complete reboot of the whole thing.  Since 2013, I know of
exactly four  developers that have taken a shot at them and that includes
you<g>.

 To my knowledge, there still remains only one web based Access app in the
windows store.

Jim.



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

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
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