I am currently running the 30 day demo and thinking about purchasing V9.
I have been developing fairly complex solutions for the aerospace industry with Access since version 1. Typical system would have anywhere from 100 to 300 tables and up to 500-600 forms reports etc. I give the users a compiled front end (mde) on the local C: drives while the datatables are on servers. I am quite comfortable with VB. I am not happy with performance once there is a fair amount of data in the tables ie. 40k records in some tables. Also when the number of users gets over about 15 performance drops off.
So what I need to know is from anyone who has moved to A5 what they have found as far as.
Security - Keeping users from modifying or even seeing the design elements. Also user security for access to forms reports etc. In Access I wrote my own security module.
Performance -- Assuming I will use an sql backend and putting the forms, reports etc on the local C: drive (If this is where the 'front end' should be). Will there be a significant performance gain.
Ease of putting in updates to the front end ie new screens or changes to screens reports etc. I often have to compile a new front end in Access then zip it and email it to a client, is this possible with A5.
Ability to create large and fairly complex systems that are visualy and functionaly appealing to the users.
Thanks in adance for any info you can provide.
I have been developing fairly complex solutions for the aerospace industry with Access since version 1. Typical system would have anywhere from 100 to 300 tables and up to 500-600 forms reports etc. I give the users a compiled front end (mde) on the local C: drives while the datatables are on servers. I am quite comfortable with VB. I am not happy with performance once there is a fair amount of data in the tables ie. 40k records in some tables. Also when the number of users gets over about 15 performance drops off.
So what I need to know is from anyone who has moved to A5 what they have found as far as.
Security - Keeping users from modifying or even seeing the design elements. Also user security for access to forms reports etc. In Access I wrote my own security module.
Performance -- Assuming I will use an sql backend and putting the forms, reports etc on the local C: drive (If this is where the 'front end' should be). Will there be a significant performance gain.
Ease of putting in updates to the front end ie new screens or changes to screens reports etc. I often have to compile a new front end in Access then zip it and email it to a client, is this possible with A5.
Ability to create large and fairly complex systems that are visualy and functionaly appealing to the users.
Thanks in adance for any info you can provide.
Comment