[AccessD] MS access shaky

[Stuart McLachlan]

I  use ODBC with as many views and stored procedures as possible to do the heavy lifting on 
the server.



On 24 May 2016 at 15:35, Lawrence Mrazek wrote:

> Quick question for the list. For those of you who are using Access
> with SQL, are you using ODBC or still using the old ADP format with
> Access 2010?
> 
> Just wondering, as we're encountering both scenarios, and are
> wondering when the
> 
> Larry Mrazek
> lmrazek at lcm-res.com
> 
> On Tue, May 24, 2016 at 3:27 PM, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> 
> > I'm still doing a lot of Access work including for a couple of
> > fairly large organisations with many users of my systems.
> >
> > Remember, Access is two things in one - a data engine and an
> > application development environment.
> >
> > There is nothing shaky about Access as a FE - it is a brilliant RAD
> > tool,
> >
> > There can be problems in some situations with Access as a data
> > engine . Primarily the result of lots of concurrent data entry into
> > the same BE database and  flaky wireless networks connections.
> >
> > For a limited number of users and primarily data extraction, it is
> > solid.
> >
> > If the concern is about the data engine, look at using SQL Server as
> > the BE to an Access FE, you get the best of both worlds.  (And it is
> > free if the Express version is sufficient)
> >
> > If the concern is about the FE, it is a non  issue.
> >
> > --
> > Stuart
> >
> >
> > On 24 May 2016 at 18:10, Kaup, Chester wrote:
> >
> > > Our IT department is trying to say MS Access is a shaky platform.
> > > I like access and don't agree with them. Anyone have any good
> > > comments? -- 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
> >
> 
> 
> 
> -- 
> Larry Mrazek
> lmrazek at lcm-res.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>