make .exe file in access

[Guest]

Hi
Can i make .exe file from my access files ? I want to make forms and tables
that user can open them independently and after filling them information go
to main file ! is it possible?
Thank You

 

[Rick Brandt]

Hi
Can i make .exe file from my access files ? I want to make forms and
tables that user can open them independently and after filling them
information go to main file ! is it possible?
Thank You

No. Access apps require Access. Access objects (forms, reports, etc.,) cannot
exist outside the Access environment. There are techniques to hide the Access
interface, but they don;t solve the problem of needin Access installed on the
PC.

You can purchase developer's tools that give you the ability (and license) to
include a free runtime version of Access that can be installed on PCs that do
not already have Access on then, but that is more involved than how it might
sound.

 

[Joseph Meehan]

Hi
Can i make .exe file from my access files ? I want to make forms and
tables that user can open them independently and after filling them
information go to main file ! is it possible?
Thank You

In short, no. They will need Access on their machine or you will need
the developer's version of access $$$ and it comes with a program that will
allow them to use the files you make but they can't make any of their own.

If they do have access you can make a MDE file and they can work with
the data, but not change the tables etc.

 

[Guest]

Joseph,

If they do have access you can make a MDE file and they can work with
the data, but not change the tables etc.

MDE files will protect forms, reports and modules only. A person who has
Access installed would still be able to add/delete/modify any tables, queries
and macros. You'd need to implement Access security to help lock down these
objects, but, as we all know, Access security is not very secure at all.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Joseph Meehan]

Joseph,


MDE files will protect forms, reports and modules only. A person who
has Access installed would still be able to add/delete/modify any
tables, queries and macros. You'd need to implement Access security
to help lock down these objects, but, as we all know, Access security
is not very secure at all.

Thanks for that information. I did not know that.

 

[Tony Toews]

Can i make .exe file from my access files ? I want to make forms and tables
that user can open them independently and after filling them information go
to main file ! is it possible?

What do you mean by independently? If you can tell us a bit more
about your objective we can give you some thoughts on solutions.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[merlelo]

hi, i have d same request here. i have a form and i wish to let my user to execute d form on desktop without openning access(but access is installed already). may i know d techniques to hide the Access interface? can i create d form exe file and let user click to input data? d form eventually will pop up a report of access(by access query). thanks~