Need Help Adding user lvl Security to 2007 version

[Army MI]

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]

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

 

[Chris O'C via AccessMonster.com]

Sorry, I mean:

You give the users a shortcut that joins the user to the secure mdw during
the session before opening the db.

Chris

 

[Army MI]

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?

 

[Chris O'C via AccessMonster.com]

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]

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.

 

[Chris O'C via AccessMonster.com]

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]

no its the default no login screen where it loads straight into the database

 

[Chris O'C via AccessMonster.com]

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]

the path is spelled out and correct but since the network discovery and file
sharing is turned off the only way is to manually access the file thru the
run coomand. but then you cant run the security file or setup a trusted
folder in Access 2007

 

[Chris O'C via AccessMonster.com]

You need a properly functioning network if you put the db file or workgroup
file - or both - on the network.

Turn on network discovery and file sharing, or use a terminal server to
connect, or use a vpn to connect. Use *something* to get a reliable network
between the pcs and the server or it won't work.

Chris

 

[Albert D. Kallal]

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?

Setup a shorcut to launch this.

The shortcut will look like:

"C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE"
"c:\program files\RidesXP\RidesXP.mdb"
/wrkgrp \\server1\database\\Rides.mdw

So, you can (should) use a shortcut to specify the workgroup file on startup
of the application......

You can use the workgroup options inside of 2007 to "join" the workgroup
file, but a shortcut is better as then all other applications that the user
launches will not be then nagged with a logon prompt. This advice also
applies to your 2003 users......