[AccessD] MS access shaky

Stuart McLachlan stuart at lexacorp.com.pg
Tue May 24 15:27:30 CDT 2016


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
> 




More information about the AccessD mailing list