Post - Error Permission Denied

[johnkoh]

Hi All,

I have the field post rule on my PO_items table. Some reason, the A5 keep sent me a Error message which is "Error posting to table Products for record 1967 Error Permission denied"

So I created the Post Operation and run it then it post the records from Po_items table to Products table.

What is wrong the error on FieldRule Posting?

[Stan Mathews]

Re: Post - Error Permission Denied

Any chance another user has/had that record open in change mode? Or you had another form open with that record open in change mode?

[johnkoh]

Re: Post - Error Permission Denied

Stan,

Is it included <tbl>.open ?

I used the Database Compact tool to check any opened tables. It runs ok.

[Stan Mathews]

Re: Post - Error Permission Denied

Is it included <tbl>.open ?

That should not cause the error unless you use

tbl.change_begin()

in the same script while the posting field rule is posting.

You can't post to a record in the products table if that record is in change mode.

[johnkoh]

Re: Post - Error Permission Denied

Stan,

How to find the left open form or table?

I went through scripts and forms but not a luck.

[Stan Mathews]

Re: Post - Error Permission Denied

Could be another field rule that fires in response to the posting field rule. Could be other things like something opening the "posted to" table in Exclusive or Read only mode.

I'd have to see the database to dig any further. Is it always record 1967 in the error message?

[johnkoh]

Re: Post - Error Permission Denied

Stan,

No, Every records from the Products table.

The fieldRule Posting does not work at all because the Locking, as Error note.

[Stan Mathews]

Re: Post - Error Permission Denied

John,

Most likely you have a conflict between two field rules.

Attach a zip of the database here or send it to me privately if you want.

[email protected]

[johnkoh]

Re: Post - Error Permission Denied

Stan,

Thank you I will do that but it is a lot

[johnkoh]

Re: Post - Error Permission Denied

Hi,

Another Permission Denied Error from another form.

Why a5 does not give me the direction?

[Tom Cone Jr]

Re: Post - Error Permission Denied

Hi,

Another Permission Denied Error from another form.

Why a5 does not give me the direction?

I think it's likely Alpha is telling you exactly what's wrong.

John, have you implemented security in this database? Is the error occurring when you log on as a member of a group that DOES NOT HAVE PERMISSION to make changes to the table Alpha is referencing?

[johnkoh]

Re: Post - Error Permission Denied

Tom,

I do not have the implemented security in this database at all.
After I deleted some coding and calculated value, and start over as new. It works fine now.

[johnkoh]

Re: Post - Error Permission Denied

Stan,

This problem came back.
This is my code on a button, push Event.

'Save record in current form at parent level.
topparent.commit()

'Find the records by current record number now and change later
dim vRcdNum as n
vRcdNum = parentform.current_record()

'Open the table that want to update...
	DIM vWrkOdrId AS c
	dim vForeman as c =""
	dim tbl as p
	tbl = table.current(1) ' get("wrkodr_hd")
	tbl.fetch_goto(vRcdNum)
	      vWrkOdrId =tbl.wrkodr_id
		
	'Listing
	DIM vForeman_rl_def_orig as C
	vForeman_rl_def_orig = "k=wrkassign,{keylist_build(\"H=.05,1:30[Avail Foreman]\",''+Emp_id,left(''+lookup(\"emp\",\"emp_id=\"+quote(Emp_Id),\"Emp_fullname\"),30))}{(Wrkodr_id = [varc->vWrkOdrId]  )  .and. unique_key_value()}"
	
	DIM vForeman_rl_def as C
	vForeman_rl_def = replace_parameters(vForeman_rl_def_orig,local_variables())
		
	'Create an XDialog dialog box to prompt for parameters.
	DIM varC_Foreman as C
	ok_button_label = "&OK"
	cancel_button_label = "&Cancel"
	
	varC_Foreman = ui_dlg_box("Foreman",<<%dlg%
	{startup=init}
	{region}
	Foreman:| [%@vForeman_rl_def%.40vForeman];
	{endregion};
	{line=1,0};
	{region}
	<*15=ok_button_label!OK> <15=cancel_button_label!CANCEL>
	{endregion};
	%dlg%,<<%code%
	If a_dlg_button = "init" then
		vWrkOdrId = replace_parameters(vWrkOdrId,local_variables())
		vForeman_rl_def = replace_parameters(vForeman_rl_def_orig,local_variables())
	    a_dlg_button =""
	end if
	%code%)

	'Execute inline Xbasic code.
	if varC_Foreman ="cancel" then
	    cancel()
	    end 
	end if
	
	If varC_Foreman="ok" then 	
		
[B][COLOR="#FF0000"]		tbl.change_begin()
			tbl.FOREMAN = convert_type(vForeman,"Character")
		tbl.change_end(.t.)[/COLOR][/B]
	END IF

'Refresh data in current form at parent level.
topparent.Commit()
topparent.Resynch()
topparent.Refresh_Layout()

I am not able add the Foreman and have an error message, Right after created new record. I have to close this form and open again then I am able to add a foreman record into table. I have several same style of this code on other forms and runs well except only two of location have the same problem, Access denied or Permission denied message. I am wondering why and what cause this?

Table.change Error.jpg

[Stan Mathews]

Re: Post - Error Permission Denied

Sounds like a Windows permissions error, not an Alpha internal error.

runs well except only two of location have the same problem

Check the user permissions for the database folder on those two machines.

[johnkoh]

Re: Post - Error Permission Denied

Stan,

I think I used wrong word here

runs well except only two of location have the same problem

I did not mean the physical computer location, I want to say "two forms button scrips" have same problem.