Split Database Problem

[Tim]

I have split a database where the back end is on the server and the front end
at a terminal. I have set up the WorkGroup file, permissions, userIDs and
passwords.

The problem comes in when I open the FrontEnd, and I think it might be
related to how I have my interface setup. Instead of using the traditional
Switchboard provided by Access, I have created a form with 2 list boxes (one
containing Reports and the other containing forms which are linked to the
MSysObjects table).

When I select a report or form and press the corresponding command button
associated with that list box, the form or report does not open.

What went wrong?

 

[Douglas J Steele]

Are you sure the code's actually firing? Sometimes the linkage between a
control and the code that's supposed to be triggered on specific events get
broken. Look at the properties of the control and ensure that the property
for the event is either a macro name, a function name (with = in front of
it), or [Event Procedure].


If that's not the problem, what's your code associated with the buttons?

 

[Tim]

the code seems to be ok. and the [Event Procedure] is present
-----
Private Sub cmdOPEN_Click()
On Error GoTo err_cmdCancel_click
DoCmd.OpenForm Me.LIST1.Value, acNormal
Exit_cmdCancel_click:
Exit Sub
err_cmdCancel_click:
Resume Exit_cmdCancel_click
End Sub
-----

Are you sure the code's actually firing? Sometimes the linkage between a
control and the code that's supposed to be triggered on specific events get
broken. Look at the properties of the control and ensure that the property
for the event is either a macro name, a function name (with = in front of
it), or [Event Procedure].


If that's not the problem, what's your code associated with the buttons?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have split a database where the back end is on the server and the front end
at a terminal. I have set up the WorkGroup file, permissions, userIDs and
passwords.

The problem comes in when I open the FrontEnd, and I think it might be
related to how I have my interface setup. Instead of using the traditional
Switchboard provided by Access, I have created a form with 2 list boxes (one
containing Reports and the other containing forms which are linked to the
MSysObjects table).

When I select a report or form and press the corresponding command button
associated with that list box, the form or report does not open.

What went wrong?

 

[Douglas J Steele]

Are you certain of what Me.LIST1.Value returning?

Also, your error handling simply ignores errors: if an error is being
raised, it might help in tracking down the problem.

For now, try changing your code to:


Private Sub cmdOPEN_Click()
On Error GoTo err_cmdCancel_click
MsgBox "Going to open " & Me.LIST1.Value
DoCmd.OpenForm Me.LIST1.Value, acNormal
Exit_cmdCancel_click:
Exit Sub
err_cmdCancel_click:
MsgBox Err.Number & ": " & Err.Description
Resume Exit_cmdCancel_click
End Sub



--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

the code seems to be ok. and the [Event Procedure] is present
-----
Private Sub cmdOPEN_Click()
On Error GoTo err_cmdCancel_click
DoCmd.OpenForm Me.LIST1.Value, acNormal
Exit_cmdCancel_click:
Exit Sub
err_cmdCancel_click:
Resume Exit_cmdCancel_click
End Sub
-----

Are you sure the code's actually firing? Sometimes the linkage between a
control and the code that's supposed to be triggered on specific events get
broken. Look at the properties of the control and ensure that the property
for the event is either a macro name, a function name (with = in front of
it), or [Event Procedure].


If that's not the problem, what's your code associated with the buttons?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have split a database where the back end is on the server and the

front
end

at a terminal. I have set up the WorkGroup file, permissions, userIDs and
passwords.

The problem comes in when I open the FrontEnd, and I think it might be
related to how I have my interface setup. Instead of using the traditional
Switchboard provided by Access, I have created a form with 2 list

boxes
(one

containing Reports and the other containing forms which are linked to the
MSysObjects table).

When I select a report or form and press the corresponding command button
associated with that list box, the form or report does not open.

What went wrong?

 

[Tim]

That solved the problem. I got a 3031 error: Not a valid password.
I put a password on the BackEnd to keep the information secure; because one
just simply open the back end and get into the database.
Is there a way to set up the password on the BackEnd so it will recognize
the FrontEnd user's password?

Also, it is taking an enternity to open a report or form, is there a way to
increase the spped or this strictly a server issue?