Permissions Problem (I think)

[Damien McBain]

What could be the problem here:

I have developed an ap which I have copied into a location on our WAN. I
split the db be/fe (both the be and fe are in the same dir). I have full
control of the network dir and it's contents, both files are read/write.

I have a save button on the data entry form in the ap. When I run the ap in
a Citrix session from the network location, I get the error "The command
'Save Record' isn't available now". I have the db emulated on my local
machine and it does exactly as it should (saves the record, displays the
msgbox etc) . Here is the code in the on click of the save button:

Private Sub btnNewRecord_Click()
On Error GoTo AwwwShit
'==================================================

If ICust = 0 Then
MsgBox "You must enter a customer", , "F.A.C.T.S."
Me!CustLookup.SetFocus
Exit Sub
End If

DoCmd.RunCommand acCmdSaveRecord
MsgBox "Failure Logged with ID# " & IID, , "F.A.C.T.S."
DoCmd.GoToRecord , , acNewRec
CustLookup = ""
Me![IType].SetFocus

'==================================================
gtfo:
Exit Sub
AwwwShit:
MsgBox Err.Description, , "F.A.C.T.S."
Resume gtfo

End Sub


Any ideas? I've used it with Citrix in a test environment and it works.

Damo

 

[Arvin Meyer]

It shouldn't make any difference for a single user, but you need Delete
permissions on the folder too, or you may get restricted. I'm not sure if
this affects how Citrix works, but without Delete permissions you cannot
create the LDB lock file, and that affects multi-user ability. Citrix may
have problems with those permission levels for a single user. Try giving
Everyone Full Control, and if that works, then throttle back to everything
but Full Control.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access