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

Jim Dettman jimdettman at verizon.net
Tue May 31 13:29:25 CDT 2016


Jim,

<<Its the double knock out punch of DAO and MDB that halted Access's ability
to ever progress beyond the desktop.>>

 I would agree on the DB engine, but not DAO. Even using ADO over a WAN with
a JET/ACE based DB can give you corruption.  It's the fundamental design of
JET itself that is the issue. But then again it was designed from the ground
up as a department level RDBMS.  

 Actually the "blue" version used with Exchange was more robust as they
added transaction level logging, but the goal was an embeddable engine and
not a general use one.

<<Aside: You can use OpenVPN which uses SSL protocol.>>

 Doesn't matter.  What matters is the basic design and as a result, the
network connectivity that is acceptable.

 Instead of one DB engine instance touching the DB, you have multiple
instances touching it.  So any problems with connectivity will give you
issues and the more connections you have, the more likely you will have
problems.   That's why it's hard to get much past 30-40 users with a
typically read/write app.   Just too many connections to keep stable.

 As far as connectivity, anything more than 30-40 milliseconds of latency
gets you into dangerous territory.  And performance wise, anything less than
40mb/sec or so yields dismal performance assuming a typically written Access
app (bound forms).   You an get a round the performance issue to a certain
extent by using a client/server type mentality, but there's no way around
the latency issue.

Jim.

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

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

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