Few final adjustments

G

Goran

Hallo,
I am trying to make some last adjustments, for convenience and security,
before deploying a secured FE-BE DB on a network. One of the things I would
like to do is disabling the design view option in the right click on a form.
What I would also like to do is to ask Access to show another message when
there in no network connection, like "Sorry the network connection is not
available at this time etc...". In both cases, I might add, Access does a
nice job providing the appropriate information; that one do not have the
permission to view the design of the form and when there is no connection,
show the path to the unavailable BE DB. I am using Access 2000. Thanks for
any help in advance!
Goran
 
J

Jerry Porter

If you implement the application using the Access Runtime, the standard
right-click menu will be disabled.

If the network connection is occurring during your code, you should be
able to use error handling to intercept the error and display a
different message. If it's a form that's generating the error, you can
use the Error event of the form.

Jerry
 
G

Goran

-Each PC has a full licence, about 50.
-The main form generates the message, on start-up. The only code in the Open
event is:
Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub
I am not sure how this is done, can I adapt the code this way?
Private Sub Form_Open(Cancel As Integer)
On Error GoTo Err_Form_Open_Click
DoCmd.Maximize
Exit_Form_Open_Click:
Exit Sub
Err_Form_Open_Click:
MsgBox Err & " " & Error$
Resume Exit_Form_Open_Click
End Sub

Goran
 
J

Jerry Porter

I doubt the error is occurring in your Form_Open event. Verify that the
error is indeed connected to the form. If you close the form and reopen
it, do you get the error again?

If so, it's an error that the form generates as it tries to access
data. To handle this type of error, you need to use the On Error event
of the form. Display the properties window for the form, and find the
On Error event.

Here's a very simple example that will display a custom message and
suppress the standard message:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
MsgBox "Sorry, unable to connect."
Response = acDataErrContinue
End Sub

Usually, you would test the value of DataErr and display appropriate
messages depending on the actual error. You can put a break point in
the code and test the value of DataErr for the errors you experience.

Jerry
 
G

Goran

- Thank you very much; this is indeed what I was looking for.
- Concerning the design view, I tested converting the FE to an .mde. Would
this be an appropriate option?

Thanks again,
Goran
 
J

Jerry Porter

I haven't tried this with and mde, so you'll have to experiment.

But I just realized there is a very simple way to turn off the context
menu in a form:
- Display the properties of the form
- Select the "Other" tab
- Change the Shortcut Menu property to "No"

Jerry
 
J

Jomark

Is there a similar method for Reports as there is no Yes/No option for the
Shortcut Menu option?
 
Top