Home All Groups Group Topic Archive Search About
Author
13 Mar 2007 5:46 AM
kt2902
Am I right in thinking that Application Title of the database cannot be
changed using VBA unless the user is a member of the Admins group?

I was trying to set the title to show who is logged on, which works fine
when it's me (as the owner of the database), or the System Admin user (member
of Admins), but doesn't work if it is one of my Full Data Users, or Read Only
Users.

Any ideas how I can work around this, or am I wasting my time?

Author
15 Mar 2007 2:21 AM
kt2902
In case anyone else comes across the same problem I thought I would let you
know how I got around it.

Decided against the whole Application Title method and instead used SysCmd
to set the status bar text. Works perfectly and IMHO actually looks more
professional than the way I was trying to achieve it in the first place. So
I'm happy, the boss is happy...

Show quoteHide quote
"kt2902" wrote:

> Am I right in thinking that Application Title of the database cannot be
> changed using VBA unless the user is a member of the Admins group?
>
> I was trying to set the title to show who is logged on, which works fine
> when it's me (as the owner of the database), or the System Admin user (member
> of Admins), but doesn't work if it is one of my Full Data Users, or Read Only
> Users.
>
> Any ideas how I can work around this, or am I wasting my time?
Author
12 Apr 2007 12:07 PM
david
needs "database administration" privilege.
is NOT the same as "member of admins" or "owner".


Show quoteHide quote
"kt2902" <kt2***@discussions.microsoft.com> wrote in message
news:CB2469F4-267E-4603-97EC-53ADAFB1D3C8@microsoft.com...
> Am I right in thinking that Application Title of the database cannot be
> changed using VBA unless the user is a member of the Admins group?
>
> I was trying to set the title to show who is logged on, which works fine
> when it's me (as the owner of the database), or the System Admin user
(member
> of Admins), but doesn't work if it is one of my Full Data Users, or Read
Only
> Users.
>
> Any ideas how I can work around this, or am I wasting my time?