Error in User, no error in Admin

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lori - 27 Jun 2006 20:05 GMT

I have a user here in the office that is getting an error when he clicks on a
command button I set up to close the form and it points to the code I wrote
for the button. I went in and pulled up the same form and it works fine. I
even tried it in another user with the same rights "Read-Only". Has anyone
ever come across this?

Signature

Thank, Lori

Reply to this Message

Douglas J Steele - 27 Jun 2006 20:19 GMT

What's the error?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I have a user here in the office that is getting an error when he clicks on a
> command button I set up to close the form and it points to the code I wrote
> for the button. I went in and pulled up the same form and it works fine. I
> even tried it in another user with the same rights "Read-Only". Has anyone
> ever come across this?

Reply to this Message

Lori - 27 Jun 2006 20:47 GMT

"Run-time error 2046. The command or action 'SaveRecord' isn't available now."

It gives you the option to End or DeBug. If I click "DeBug" It opens the
visual basic code screen and highlights "DoCmd.RunCommand acCmdSaveRecord".

Signature

Thank, Lori

> What's the error?
>
[quoted text clipped - 7 lines]
> anyone
> > ever come across this?

Reply to this Message

Douglas J Steele - 27 Jun 2006 21:12 GMT

Does the user have the ability to update records in the database otherwise?
It's possible that he doesn't have the correct permissions to the folder
where the MDB file exists, so that he's only got read-only access.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> "Run-time error 2046. The command or action 'SaveRecord' isn't available now."
>
[quoted text clipped - 12 lines]
> > anyone
> > > ever come across this?

Reply to this Message

Lori - 27 Jun 2006 21:31 GMT

No, he is set up as read-only. I really don't want him set up as anything
but read-only. Is this a problem?

Signature

Thank, Lori

> Does the user have the ability to update records in the database otherwise?
> It's possible that he doesn't have the correct permissions to the folder
[quoted text clipped - 20 lines]
> > > anyone
> > > > ever come across this?

Reply to this Message

Douglas J. Steele - 27 Jun 2006 22:03 GMT

It he's read-only, what are you expecting the SaveRecord to accomplish?
SaveRecord implies update...

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> No, he is set up as read-only. I really don't want him set up as anything
> but read-only. Is this a problem?
[quoted text clipped - 28 lines]
>> > > anyone
>> > > > ever come across this?

Reply to this Message

Lori - 29 Jun 2006 16:44 GMT

Because two of us update the records and it is needed in the code when we
enter and edit data.

Signature

Thank, Lori

> It he's read-only, what are you expecting the SaveRecord to accomplish?
> SaveRecord implies update...
[quoted text clipped - 31 lines]
> >> > > anyone
> >> > > > ever come across this?

Reply to this Message

Douglas J Steele - 29 Jun 2006 17:11 GMT

Realistically, there's probably no reason for the SaveRecord: Access is
supposed to automatically save changes for you (although there are a few
cases where it gets confused)

What you can try is to only save if the record needs to be saved:

If Me.Dirty Then
DoCmd.RunCommand acCmdSaveRecord"
End if

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Because two of us update the records and it is needed in the code when we
> enter and edit data.
[quoted text clipped - 34 lines]
> > >> > > anyone
> > >> > > > ever come across this?

Reply to this Message