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?

 

[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?

 

[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.

 

[Army MI]

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

 

[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

 

[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......