[AccessD] MS access shaky

[Doug Steele]

ODBC for connecting to SQL Server.  I use a few stored procedures to
generate views when I run into complex recordsets that are slow to create
in Access.

Doug

On Tue, May 24, 2016 at 1:35 PM, Lawrence Mrazek <lmrazek at lcm-res.com>
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
>