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

[Jim Dettman]

<<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>>