>You do the same thing you're doing with every other version of Access with
>user level security.  (Aren't you?)
>
>You give the users a shortcut that joins the user to the secure db during the
>session.
>
>"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
>
>Users remain joined to the default system.mdw file so they can open any db
>without security and not be prompted to login - until they use the shortcut
>for the secure db.
>
>Chris
>
>>I have a DB created in MSA 2003 with the user lvl security setup for my 7
>>users.  But one of my users has MSA 2007 version.  I am used to going to
>>tools security and selecting the security file.  but how do you do that
>>through MSA 2007 in order to get the user logon screen to show up?

"Chris O'C via AccessMonster.com" wrote:

> You do the same thing you're doing with every other version of Access with
> user level security.  (Aren't you?)
>
> You give the users a shortcut that joins the user to the secure db during the
> session.
>
> "path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
>
> Users remain joined to the default system.mdw file so they can open any db
> without security and not be prompted to login - until they use the shortcut
> for the secure db.
>
> Chris
>
>
> Army MI wrote:
> >I have a DB created in MSA 2003 with the user lvl security setup for my 7
> >users.  But one of my users has MSA 2007 version.  I am used to going to
> >tools security and selecting the security file.  but how do you do that
> >through MSA 2007 in order to get the user logon screen to show up?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1
>
>

"Chris O'C via AccessMonster.com" wrote:

> There's no getting around it.  If the pc is disconnected from the network,
> the shortcut won't work if the path is *on* the network.
>
> Make sure you're connected to the network and you have permissions to the
> network folder before running the shortcut.
>
> Chris
>
>
> Army MI wrote:
> >this worked great but i have one problem.because i run off a network not
> >administatively managed by me each time i use the shortcut it says it cant
> >find the file.  i think this is because the Network Discovery and File
> >sharing are turned off on the vista computer that is trying to connect to my
> >xp version.  any ideas?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1
>
>

"Chris O'C via AccessMonster.com" wrote:

> Do you mean you get the login for user name ("Admin") and password or do you
> mean it tries to open the db with the default admin user without prompting
> you for the user name and password?
>
> If it's the former, change the Admin user name to your user name.  Type your
> password in the 2nd box to open the db.
>
> Chris
>
>
> Army MI wrote:
> >well i can use the run command and manually connect to the folder on the
> >network.  and then manually open the access database but then i can get the
> >login sccreen to show up.  it just goes to the default admin which i dont
> >have permissions set for.
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1
>
>

"Chris O'C via AccessMonster.com" wrote:

> That means your shortcut isn't joining you to the secure mdw file for the
> session.  Make sure the paths in the shortcut are the full paths, not just
> the file names.  Make sure everything is spelled correctly.
>
> Chris
>
>
> Army MI wrote:
> >no its the default no login screen where it loads straight into the database
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200906/1
>
>