Urgent!!!

[chaya]

Hi,
How can I create an installation file only the application window ACCESS? Also no access to code?(just forms!!!)
Chaya

 

[SydneyGeek]

A very quick summary...

Split the database so that the tables are in another, linked database.
You will need to create all the forms, then define a startup form (eg, a menu form or switchboard).
Then change the startup options so that the database container is not visible.
At that point you can turn the front end database into an .mde or .accde file, with all of the forms and reports compiled and no design options. KEEP A COPY OF THE ORIGINAL or you will be unable to make any changes to the design.
Give users the .mde front end; each user needs their own copy, placed on their PC.

If you want to give it to users who don't have Access installed you will need to create a runtime version of the database. For 2007 and 2010 it's free; for earlier versions you need various developer tools (what you need depends on the Office version)

Denis

 

[chaya]

Hi Denis,
Thank you for your response, I'd love to get more details of how perform any action.
The Office version is: Access 2007
I downloaded already the runtime version of the database, But there is a difference in display properties, other colors ...
Sincerely yours,
Chaya

A very quick summary...

Split the database so that the tables are in another, linked database.
You will need to create all the forms, then define a startup form (eg, a menu form or switchboard).
Then change the startup options so that the database container is not visible.
At that point you can turn the front end database into an .mde or .accde file, with all of the forms and reports compiled and no design options. KEEP A COPY OF THE ORIGINAL or you will be unable to make any changes to the design.
Give users the .mde front end; each user needs their own copy, placed on their PC.

If you want to give it to users who don't have Access installed you will need to create a runtime version of the database. For 2007 and 2010 it's free; for earlier versions you need various developer tools (what you need depends on the Office version)

Denis

 

[SydneyGeek]

To split the database: http://support.microsoft.com/kb/304932

Define a startup form: http://www.utteraccess.com/forum/Open-form-startup-t1950814.html

For 2007 you will need to be using the new .accdb format; you can then convert the file to an .accde file. To create the .accde: http://office.microsoft.com/en-us/access-help/hide-vba-code-from-users-HA010239557.aspx

Note: The run-time version is very limited. You use some features, and you have to be absolutely sure that there won't be any errors that try to take you to Debug because that option is not available in Runtime.

What exactly are you trying to do?

Denis

 

[HiTechCoach]

I run 100% of my front end with the Access runtime. I have not found it to be limited at all. The only limit out of the box is the that UI is stripped down. It does requires the developer to do more UI work.

This may help: What is the Access Runtime Version?