error: this operation violates your permissions configuration

[Former Community Member]

Hello: I have a form with a dropdown list and 4 text fields.



The dropdown list has 3 values (Committee 1, Committee 2, and committee 3)



In access 2007 I have a database with the names of the people on each committee.



The following code is on the exit button of the dropdown list:



$sourceSet.TIMSTEST.#command.query.commandType = "text"

$sourceSet.TIMSTEST.#command.query.select.nodes.item(0).value = Concat("Select * from Tmp_Committee where Description = '", this.rawValue, "'")

$sourceSet.TIMSTEST.open()

//xfa.host.messageBox("TIMSTEST opened")



$sourceSet.TIMSTEST.close()

//xfa.host.messageBox("TIMSTEST closed")



When I open the form I automatically get the first record in the database.

When I choose another value in the dropdown I get this error:



error: this operation violates your permissions configuration



Please help.



Thank you

[_Kirill_Krylov_]

Have you been able to resolve this issue. I have exactly the same when I am trying to pass any SQL statement. Please help !!!

[Former Community Member]

When you set up the connection in the dataview you must choose the delayed open option. It is a checkbox on the bottom of the last screen on the wizard. If youdo not check this off the connection is established when the form is opened and the 1st reord is returned (by default). By delaying the open, you can set your commands (like in your script) then when you do the open then you wil get the correct record.

[MsPatil]

Even after i check the Delay Open check box i get same error

xfa.sourceSet.DataConnection.#command.query.commandType

= "text"

I get same error after adding above line

any help would be appriciated

[Former Community Member]

In Form Properties/Default there is a target version ...what is it set to?

Paul

[MsPatil]

i dont see target version in form properties/default....i see it under fprm property/info

8.0.1291.1.339988.308172

[Former Community Member]

That number is the version of Designer. If you look under the File menu/Form Properties/ Defaults Tab - the 1st option is a target version of the client that you are designing for.

Paul

[MsPatil]

Thank you for your response,Paul

Am attaching screen shot of my Default tab for your reference

Am designing this form to create mailing labels.

Please let me know if i can get any info about this on this forum

Thank You

[Former Community Member]

This tells me you are using version 8 of Designer ...yes? Are you using Reader to view the form?

Paul

[MsPatil]

yes, Paul

[Former Community Member]

Reader does not allow DB connections by default. You must Reader Extend the form using LiveCycle Server to allow for this functionality. If your users  are using Acrobat Pro you will not have to do this.

Paul

[MsPatil]

Thank you Paul

since am new to Adobe forms i dont know what do you mean by "You must Reader Extend the form using LiveCycle Server" and how to do this?

Thank you

[Former Community Member]

Before we go down that path I suggest that you download a trial copy of Acrobat Pro and ensure that you do not get the same issue. If that works then we can confirm that I am correct.

Paul

[MsPatil]

Paul, Thank you for your quick response

Am downloading trial version of Acrobat Pro but is there anything i can do using livecycle Designer to make this work?

[Former Community Member]

No ...I do not belive it is a Designer issue.

Paul

[MsPatil]

Hello Paul,

I downloaded trial version of Acrobat Pro 9. when tried to launch it it asks

for serial number and I did not get serial number

Thanks

[Former Community Member]

I think if you continue without a number you get a 30 day trial....but I am not certain.

Paul

[MsPatil]

I had tried that but did not work

Can we resolve the permission issue in Livecycle designer?

I followed the steps from the link below and still get "This operation

violates your permissions configration" error

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

Any advice would be appriciated

thanks

[Former Community Member]

Thats because when you preview you are still using the Acrobat/Reader that is on your machine. Here is the download site for the trial version of Acrobat:

http://www.adobe.com/products/acrobatpro/tryout.html

Paul

[Former Community Member]

Try changing your target version in the Form Properties to version 8  or 7 and see if the message goes away.

Paul

[MsPatil]

I cannot see target version in the form properties

Also, is there any example I can refer to create simple query form which I

can put across my network and access....we want to access for from our

Intranet system

Well, looks like nothing is working for me....neither I got serial number to

try Acrobat Pro nor I can make this work

Thanks