a question regarding setting up access security

[bkalimili]

After reading the document which every one is pointing too, the one that is available in Microfsoft.
I have used the user level security wizard, added two users, primarily first to test it. I saved the userid and pwd information in snapshot format.

I gave myself adiministrator previlage, other user as data-read only.

I see it creates 3 files,

1) .mdb
2) .bak
3) .mdw

a shortcut is also created on the desktop, if we choose not to use the workgroup for default purposes.

Basically, if it is on my desktop, if I open thru short cut, it prompts me the username and password which is fine.

I want to place it in a shared drive on the serve, basically for multiple users to use the database.

I copied the short cut on the other user desktop and made some changes in shortcut propert.

If I right click the shortcut on desktop,

Where it says target I see there are 3 prameters.

"C:\Program Files\Microsoft Office\Access\Office\MSACCESS.EXE" "G:\MSOF_Control_Execution\FAS140&FIN45\Team Workspace\C10198_Kalimili\securitytest\workgroup.mdb" /WRKGRP "G:\MSOF_Control_Execution\FAS140&FIN45\Team Workspace\C10198_Kalimili\securitytest\testw.

Start has "G:\MSOF_Control_Execution\FAS140&FIN45\Team Workspace\C10198_Kalimili\securitytest\"

On other users desktop, I made sure I pointed both the target and start to right path.

On desktop it runs fine, other users desktop
It gives me following error.

‘Microsoft could’nt find the file
"G:\MSOF_Control_Execution\FAS140&FIN45\Team Workspace\C10198_Kalimili\securitytest\testw”, the file is required for start up.

Thanks

 

[Bat17]

I suspect he short cut should be:-

"C:\Program Files\Microsoft Office\Access\Office\MSACCESS.EXE" "G:\MSOF_Control_Execution\FAS140&FIN45\Team Workspace\C10198_Kalimili\securitytest\workgroup.mdb" /WRKGRP "G:\MSOF_Control_Execution\FAS140&FIN45\Team Workspace\C10198_Kalimili\securitytest\testw.mdw"

HTH

Peter

 

[TechRazor]

We are doing exactly what you want at our work. Here is what you need to do.

1. Make the folder "securitytest" shared so that everybody can access it on the network.

2. Change the properties of the shortcut to reflect the shortcut. Here is an example

C:\Program Files\Microsoft Office\Access\Office\MSACCESS.EXE" "\\computername\securitytest\workgroup.mdb" /WRKGRP "\\computername\securitytest\testw.mdw

Also change "start in" to \\computername\securitytest

Now the other computers will know where the database is located. Hope this helps.

 

[bkalimili]

Thanks All.