I finished the application - - - now what?

[Chuck Insight]

Hi All,

I just finished creating my first all-inclusive MS-Access application. Ideally, I would prefer to prevent mischievous users from accessing everything except the switchboard items. This would include the menu system and except for the "print" shortcut button, all the control buttons. In fact, if I could somehow automate printing reports, I would hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

[Salad]

Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

[Salad]

Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

[Chuck Insight]

Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...

Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

[Chuck Insight]

Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...

Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

[Salad]

Chuck Insight wrote:

Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
Since the user can only view a switchboard, what functionality is there
but exiting the app?

"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...

Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

[Salad]

Chuck Insight wrote:

Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
2 - exits the application if the user exits the switchboard,
3 - prohibits viewing everything but the switchboard, yet
4 - supports all the functionality built into the application

Again, thanks
Since the user can only view a switchboard, what functionality is there
but exiting the app?

"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...

Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would
hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck

Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a form.

[New Guy]

On Sun, 17 Jul 2005 20:28:26 GMT, Salad <oi*@vinegar.com> wrote:

Since the user can only view a switchboard, what functionality is there
but exiting the app?

I'm sorta new at Access but I have written some apps using VB and
Access in the back but I have never come across the term switchboard?

What does it mean?

Thanks.

[New Guy]

On Sun, 17 Jul 2005 20:28:26 GMT, Salad <oi*@vinegar.com> wrote:

Since the user can only view a switchboard, what functionality is there
but exiting the app?

I'm sorta new at Access but I have written some apps using VB and
Access in the back but I have never come across the term switchboard?

What does it mean?

Thanks.

[Rog]

New Guy,

A switchboard is a system of one or more menu forms. You can use the
switchboard manager (under tools / add-ins) to create one.

Rog

[paii, Ron]

"Chuck Insight" <j.*******@insightbb.com> wrote in message
news:y6yCe.162031$_o.44926@attbi_s71...

Thanks for this reply, but this will not quite get the complete job done.

Closer to what I had in mind would be making an executable file that:
1 - hides everything except the auto-execute opening switchboard,
Right click on the database window, click on startup.
Enter you swichboard form in Display Form: "May not need autoexec
macro"
Uncheck display database.
2 - exits the application if the user exits the switchboard,
Add "Application.Quit acPrompt", to the On close event of your switchboard
3 - prohibits viewing everything but the switchboard, yet
These are 2 soft security steps, easily bypassed by knowledgeable users.

Add a macro named {F11} to disable using F11 do display the database.
Create a new application toolbar and have your switchboard switch it for the
default.
4 - supports all the functionality built into the application

Again, thanks
"Salad" <oi*@vinegar.com> wrote in message
news:T%*****************@newsread1.news.pas.earthl ink.net...

Chuck Insight wrote:

Hi All,

I just finished creating my first all-inclusive MS-Access application.
Ideally, I would prefer to prevent mischievous users from accessing
everything except the switchboard items. This would include the menu
system and except for the "print" shortcut button, all the control
buttons. In fact, if I could somehow automate printing reports, I would hide it, too. Please reply with any recommendation.

Thanks very much,
Chuck
Create an autoexec macro. In the macro, run your reports, then quit the
app. You may want to inform the users the reports are running via a

form.