Re: Should we Convert to Access 2007?

I came up with an interesting solution. I was able to copy the
default system.mdw file from Access 2003 over to Access 2007. Then
using the RunCommand acCmdWorkgroupAdministrator Module I created I
could join the default system.mdw i just copied over. No more
prompting for the name and password!

Thanks again for your help.



On Feb 28, 10:45 am, WPW07 <wwisnie...@xxxxxxxxx> wrote:
On Feb 28, 9:43 am, "Allen Browne" <AllenBro...@xxxxxxxxxxxxxx> wrote:

Can I suggest that you open the Immediate Window (Ctrl+G), and actually try
the commands?

Thanks again. I successfully was able to connect using RunCommand
acCmdWorkgroupAdministrator. Now when I open access 2007 to connect
to a different database it still asks for my logon name and password!
How do I disable it?



Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"WPW07" <wwisnie...@xxxxxxxxx> wrote in message

news:afe489a7-d0da-4981-8099-24eb3b16b768@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Does that mean I do need all three RunCommands?

RunCommand acCmdWorkgroupAdministrator
RunCommand acCmdUserAndGroupAccounts
RunCommand acCmdUserAndGroupPermissions

.

Relevant Pages

  • Re: Should we Convert to Access 2007?
    ... But I do include the buttons that fire up the ... groups/account permissions. ... RunCommand acCmdUserAndGroupAccounts ... RunCommand acCmdUserAndGroupPermissions. ...
    (comp.databases.ms-access)
  • Re: Should we Convert to Access 2007?
    ... I successfully was able to connect using RunCommand ... Now when I open access 2007 to connect ... to a different database it still asks for my logon name and password! ... RunCommand acCmdUserAndGroupAccounts ...
    (comp.databases.ms-access)
  • Re: Command Button "Find"
    ... Did adding the RunCommand help? ... Allen Browne - Microsoft MVP. ... Tips for Access users - http://allenbrowne.com/tips.html ... When I exit out of my Main Menu and open my "Members/Contributions" form ...
    (microsoft.public.access.forms)
  • Re: DoCmd.DoMenuItem in Access 2007
    ... The 500 odd options in RunCommand provide most of the old DoMenuItem functionality. ... They all start with acCmd, and they are generally not that hard to spot if you have an idea of what you want to do, e.g.: ... Tips for Access users - http://allenbrowne.com/tips.html ... The command button wizard in previous versions of access made extensive use of DoCmd.DoMenuItem which isn't available in 2007 ...
    (microsoft.public.access.forms)