 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2008new project to work on
I have not written VBA behind access before. What I need to do at my new job is to write an application where users can enter data into 'screens'. The data that is entered will end up in access. Once the data is entered into access, I will then export the data to vartious sql server 2005 databases for processing. This application is not suppose to be a web aplication. The application is suppose to be like an 'exe' that someone can click on and then execute. I am wondering how to accomplish this task and what security issues would I need to be aware of. Thanks! Access front-ends (code, forms, queries, and reports) are not 100% secure (but then security is relative anyway) The are not executables, nor can you make an executable from one. You need to have Access installed to run them. There are runtime versions of Access that can be created with developer toolkits. Everything you want to do is doable by someone with programming experience, who is willing to learn VBA, which is very close to VB6, with the application specific additions.  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com >I have not written VBA behind access before. What I need to do at my new >job [quoted text clipped - 10 lines] > > Thanks! Almost everything about Access can be learned using trial and error. You will need some VBA experience to get everything running the way you want it. DO NOT ATTEMPT TO SET UP ACCESS SECURITY WITHOUT A FULL GUIDE TO HELP YOU. I would recommend: http://www.geocities.com/jacksonmacd download the first file – Security Paper by Jack Macdonald. It’s a little long but it tells you everything you need to know. > I have not written VBA behind access before. What I need to do at my new job > is to write an application where users can enter data into 'screens'. The [quoted text clipped - 7 lines] > > Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.