9 replies
by sl-campbell
I would say "Yes" - IF used right. Users of Ms Access are often mislead into bad program habits and techniques. (MS Access developers had and have the novice user mainly in mind, but it has advanced over the years to be able to offer advance programmers a fast and easy method to create smaller applications). While alot of the techniques suggested to used in MS Access may be alright for simple projects, beginners, and for learning purposes, they are in no way suitable for mission critical and intensive applications with a large number of records, but that doesn't mean Access isn't able.
Like I said -"...if used right" then it can be made suitable, and if you are an advanced programmer and already know how to use the correct programming techniques, and then apply them in MS Access, then it is alright - but then I would say at that point why use Access?
by janez.vovk
by miss kitty
Hi. With our SQL system, I have to use Access in order to extract data from the SQL databases. From Access I can export the information in a text delimited file to use elsewhere. Access works good in this respect. You could set up Access to run various queries against the database and use the info in reports.
Cathy
by janez.vovk
by bob sellman
Access will certainly speed up your application development as compared to using, for example, VB. For that reason, Access could be a good choice to develop the system, especially if your users are willing to test the application (using, of course,a test SQL database!) as you are developing it. You can then respond more easily and quickly to their requests, suggestions, and comments.
Be sure that your queries are pass-through queries so that processing is done at the SQL server, rather than by the workstation.
Remember that all users must have a licensed copy of the same version of Access. If users do not have this and you have many users, the use of VB might be less expensive, at least as far as paying for software on users' workstations.
After you have your system working, you may find it worth re-writing in something like VB, depending upon the complexity of the application, in order to pick up some speed.
by janez.vovk
by jaikumar
by janez.vovk
by janez.vovk
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending