[AccessD] MS access shaky

[Lawrence Mrazek]

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