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

Jim Lawrence accessd at shaw.ca
Tue May 31 12:16:14 CDT 2016


Actually, I ran some huge ADO WAN data networks but the backend was not a MDB. Its the double knock out punch of DAO and MDB that halted Access's ability to ever progress beyond the desktop.

You are right that the new Access is the Access of old in name only.

Aside: You can use OpenVPN which uses SSL protocol. It is a encrypted tunnel that can run across the network or anywhere on the internet. To the client, this tunnel is just another local drive letter or location. New routers by netgear, use WRT and OpenVPN software (they limit access to six connections but for a small cheap router this is probably a physical limitation.)

Jim

----- Original Message -----
From: "Jim Dettman" <jimdettman at verizon.net>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, May 31, 2016 5:01:07 AM
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



More information about the AccessD mailing list