Macros

[#1]

Hi,

I had written the macros to write back to the database. Once i have deployed it. It is not working. Do i need to change any settings. Please let me know steps. As of now i called the macro through the button action.

[kaushalview]

Hi

XXX

1.First u check ur macro code right or not.

2.go to the setting ----->Document----->Security---->Check the Macro Override Property .

3. Plz see img

Regrard

Kaushal Mehta

[amars]

Hi

I am not very sure about this but check User Preferences -> Security -> Script(Allow Database Write and Execute Statements) is checked or not.

thanks

[kaushalview]

hi

I attached screenshot img

Regrads

kaushal mehta

[#5]

Thanks for all your responses.

I have fixed the issue.

I have used the macro to establish DB connection,Open the database and write the Query it is not necessary to enable the Open databases in Read and Write Mode option.

I have enabled the server settings now. Also i removed the msgbox from the vbscript macro and now it is working.