I have a VB application using an access database containing some Access reports. Runtime Access is supplied to the user along with VB exe so user may not have full Access. From time to time, the page settings for a label report are reset to defaults, so I wish to have a VB routine that can put the correct values back into the report.
Unfortunately, the DoCmd.OpenReport method doesn't seem to want to use the acViewDesign setting to update these values. I get a message "Need exclusive use of db to do this" even though it already has this.
Is this because DoCmd.OpenReport acViewDesign doesn't work with Runtime?
If it doesn't, anyone got any ideas how to change these values from VB?
Thanks in anticipation.
Unfortunately, the DoCmd.OpenReport method doesn't seem to want to use the acViewDesign setting to update these values. I get a message "Need exclusive use of db to do this" even though it already has this.
Is this because DoCmd.OpenReport acViewDesign doesn't work with Runtime?
If it doesn't, anyone got any ideas how to change these values from VB?
Thanks in anticipation.
