new project to work on

[Wendy Elizabeth]

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!

 

[Arvin Meyer [MVP]]

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.

 

[Olduke]

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.