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

[Doug Murphy]

My only point in joining this discussion was to correct the statement that
web hosts won't allow mdb files on their sites. All the windows hosts that I
am familiar with have no problems with mdb. They may not do the dns for you
but using dns-less connections makes this irrelevant. An mdb isn't a high
traffic data store but for a low traffic site that has some data storage
requirements they work just fine if SQL server or MySQL are not available.
Using ADO you can get pretty good performance with web pages. Drew pointed
this out many moons ago.

I cannot defend MS for what they have done to Access, trying to pervert it
to the Swill Army Knife for database systems. The Access client applications
are still relevant, and cost effective, particularly when coupled with SQL
server for the back end. Access for web Apps or development is not a
solution. If you want to do web apps or Web sites, or Apps in general
Microsoft has provided a great environment in Visual Studio. They have
provided the Windows developer with tools to play in all arenas, Web
development that can incorporate all the latest frameworks e.g., Anugular,
React, NodeJS, JQuery, and many more that I am not familiar with. You can
create native phone apps for Android or IPhone using Xamarin, web apps with
ASP.NET. And they give the basic development environment to your at no cost
in the Visual Studio Community edition. Let's be honest, if you're going to
develop systems to work on the web you're going to have to pay your dues and
learn some web technology HTML, Java Script, CSS, C#, PHP or some
development language. You may get tools to do some of the work like Access
will build forms and reports but, you will eventually have to pop the hood
and customize. And for security reasons you should know how the technology
works.

Arthur likes Alpha Anywhere which looks like a great tool, but to me is
limiting in hosting options and is expensive. I have nothing against it,
just like to create things that I have control over.

I am encouraged by the direction MS is taking in general, but discouraged
with the latest versions of Access. 

Doug

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim
Dettman
Sent: Tuesday, May 31, 2016 5:01 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Help with an Access web app -- finding records
without matching related records


<<Excellent example.>>

 Not really...no matter what, you can't run JET/ACE over a WAN, unless it's
a very high end one.  DAO or ADO, it doesn't matter. 

 If your talking about RDP'ing onto a sever and running locally, then yes,
you can be "in the cloud".   But the hosting does need to be more than a
simple file share.   It must be hosted on a OS that has the ability to place
locks on a file.  You can't use something like One Drive or Dropbox.

 Looking back over the thread, I'm not sure where this went astray, but
Susan was referring specifically to Access Web Apps, which are "Access" in
name only.

 They are developed with the Access Client like a desktop DB, but they are
hosted through SharePoint, and store data in a Azure DB.  Here's a good
overview:

https://msdn.microsoft.com/en-us/library/office/jj250134.aspx

 This is what I was talking about that so far, has gone no where.

 If missed understanding at some point and am stating the obvious, my
apologies, but it seems like this went off track somewhere along the line.

Jim.

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

Excellent example.

Jim

----- Original Message -----
From: "Martin Reid" <mwp.reid at qub.ac.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, May 28, 2016 1:27:20 PM
Subject: Re: [AccessD] Help with an Access	web	app	--
finding	records	without matching related records

https://msdn.microsoft.com/en-us/library/ms971485.aspx
________________________________
From: dw-murphy<mailto:dw-murphy at cox.net>
Sent: ‎28/‎05/‎2016 20:38
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



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

<<Snip>>


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