[AccessD] MS access shaky

[Darryl Collins]

Always ODBC.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lawrence Mrazek
Sent: 25 May, 2016 6:36 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] MS access shaky

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