Miguelito Miguelito

Niner since 2010


  • The Access Show: Access 2010 demo of Access Services and web databases

    Completely in agreement with brice I continue working with access 2003 for the same reasons and also I think that the use of macros is BIG setback

    The examples that I see are on simple things but I  want to see an example of a real update of inventory
    first where the record is looked by the previous information (deleted table in TSQL), two options are had exist or do not exists if it exists to add record to assign values to every updated field and to save record

    then to do the same thing with the new information (inserted in TSQL) two options are had record exists or does not exists if it exist to add record to update fields and to save record

    More or less this it is the work in the real world, in Vb code approximately 20 lines but in macros approximately 20 pages!!


    all my critiques are to MsAccess in the role of database NOT as front-end
    My last suggestion to avoid this eternal and useless confusion is to put " Access Front End " extension (AFE) to.mdb files front end AND " Access Back End " (ABE) to mdb files with only tables, because by example I send many topics to Kallal about the use of Mysql and Triggers and the answer was "Mysql don't have forms, reports, etc"