Re: Recordsource only available to Administrator on clients

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

they don't need windows administrator priveleges

can't you just give the other windows users the datareader and datawriter roles and things are peachy?

it sounds to me like you're locking down too much



"John Hackert" <hackertjohnb@xxxxxxxxx> wrote in message news:1180502449.131621.147060@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Sylvain,

Of course I'm grateful that you've been willing to try to help me.
Nonetheless, as I mentioned, the SQL Server database and ADP in
question works flawlessly in a single user environment and likewise
works flawlessly in the tested multiuser environment when the users
have Windows administrator privileges.

The phenomena I have described only occur in a multiuser environment
when the client users are restricted to non-administrator privileges
at the Windows level.

If I was observing bizarre behaviors across the board, it would
definitely makes sense to look for things like naming conflicts,
reserved words, etc.

All of what I've described could be considered irrelevant if I could
simply gain some understanding of the significance of the empty white
circle versus the green circle with the white arrowhead in SQL Server
Management Studio Express on a client computer. This observation
would seem to be completely independent of the ADP format and would
therefore seem to be relevant for any user of SQL Server. Perhaps a
Microsoft monitor would be willing to respond to this important issue.


.