Limited user permissions problem

[Duncan]

I'm using a piece of Visual Basic code in an Access 97 database so that,
when the user clicks on the relevant button, Word 97 is started, a
specfic letter template is opened which is then populated with data from
fields in the database.

[The database is on an server running NT Server 4, with the templates on
each client machine (located at C:\Standard Letters\Templates).]

I have a mixture of NT4 Workstation and XP Pro client machines.
Everything works great on the NT machines, and when logged in with
administrator privileges on the XP machines.

However, when logged on to the XP machines as a normal user (a member of
"Domain Users" using a roaming profile), Word starts when the button is
clicked, and the relevant template is loaded, but no data is pulled
across from the database.

I've had a dig around the MS KB and Google Groups but have not found any
pointers towards a solution yet. I've also tried to use a file/registry
monitor to pinpoint when/where the problem occurs, but cannot find one
of any use that will run when logged on as a limited user.

The folder where the database resides on the server and the folders
containg the install of MS Office and the templates are all shared with,
at present, Full Control for Everyone.

I'd be grateful for any suggestions.

Duncan McKenzie

 

[Kent W. England [MVP]]

I'm using a piece of Visual Basic code in an Access 97 database so that,
when the user clicks on the relevant button, Word 97 is started, a
specfic letter template is opened which is then populated with data from
fields in the database.

[The database is on an server running NT Server 4, with the templates on
each client machine (located at C:\Standard Letters\Templates).]

I have a mixture of NT4 Workstation and XP Pro client machines.
Everything works great on the NT machines, and when logged in with
administrator privileges on the XP machines.

However, when logged on to the XP machines as a normal user (a member of
"Domain Users" using a roaming profile), Word starts when the button is
clicked, and the relevant template is loaded, but no data is pulled
across from the database.

I've had a dig around the MS KB and Google Groups but have not found any
pointers towards a solution yet. I've also tried to use a file/registry
monitor to pinpoint when/where the problem occurs, but cannot find one
of any use that will run when logged on as a limited user.

The folder where the database resides on the server and the folders
containg the install of MS Office and the templates are all shared with,
at present, Full Control for Everyone.

I'd be grateful for any suggestions.

Duncan McKenzie

Try changing the permissions on the Access 97 database folder in Program
Files. Change Users Group from read-execute to "modify" permissions.

If that doesn't help, run your registry and file monitor from an admin
account and see if anything is accessing HKLM registry keys for writing
or writing to files in Windows, Program Files, or other folders that
don't allow Users to write to.

If that doesn't help, write or use a simple database access program or
scriplet that works in admin but doesn't work limited. Then you can
focus on database permissions as the cause. Can you set permissions on
specific database record/field entries?