User level security Shortcut

[Mansoor Ahmad]

I have set user lever security on my database. At the end of the wizard it automatically created a shortcut on my desktop. By clicking on this short cut it prompts for the user name and password.

My question is when other users would want to use the database on there computers on the network, how would they create shortcut on their desktops. Because I have tried to create another shortcut for the same database, it doesn’t prompts for any username and password, it opens but doesn’t allow to do anything. On the location path of short cut, there are two different files mentioned on C drive. If users are using their own computers how can they access to that shortcut?

Would anyone please help me here?

Thanks

 

[Newman]

The three files in the shortcut are:
-Access program : Their Access program should have the same path on their computers.
-The database : That one should be on the network not on your PC.
-The System.MDW file (security file) : That one should be on the network as well.

I could bet that the last one is the one that is not at the right place. It is a mistake that many programers do the first times.

For the shortcut, create the first shortcut on the network, and leave it there. All the users will have to do is copy and paste that shortcut where ever they want to.

 

[Autoeng]

See this (unfortunately long) post about distributin a db over a server.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=36445

Autoeng

 

[Mansoor Ahmad]

Short cut file path too long

I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file.

Is there any other way aroung? Or I will have to change to location of database itself?

Looking forward to your reply.

Thanks

 

[Mansoor Ahmad]

Short cut file path too long

I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file.

Is there any other way aroung? Or I will have to change to location of database itself?

Looking forward to your reply.

Thanks

 

[Mansoor Ahmad]

Short cut file path too long

I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file.

Is there any other way aroung? Or I will have to change to location of database itself?

Looking forward to your reply.

Thanks

 

[Mansoor Ahmad]

I have understood it now but there is a little related problem. When I create short cut on desktop, the file locaiton path is too long to fit into the Target window so cannot open the databse security workgroup information file.

Is there any other way aroung? Or I will have to change to location of database itself?

Looking forward to your reply.

Thanks

 

[Autoeng]

I don't think there is a limit to the length of a command line. My command line will not completely display in the Target box but if I click in the box I can scroll to the right to see the rest of the command.

Autoeng

 

[Mansoor Ahmad]

Autoeng

Thank you for your reply.

Follwing is the path that I am trying to put in the Target cell but the end part which is the file name doesn't display in it and when I try to put cursor to add the name it beeps, wouldn't allow.

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "G:\Plant 0130 (FS)\Quality\Quality_Warranty\Warranty Analysis Database\WARRANTY DATABASE\WARRANTY.mdb" /WRKGRP "G:\Plant 0130 (FS)\Quality\Quality_Warranty\Warranty Analysis Database\WARRANTY DATABASE\Workgroup information file.mdw

Thanks

 

[Autoeng]

Tried it myself and I see your problem. Do this instead. Open Wordpad or Notebook and enter the path into a blank document. Save the file with whatever name you like. Rename the file to end with .bat. Now you have created a batch file which will do the same as a shortcut.

Autoeng

 

[Mansoor Ahmad]

You are great. It worked very well.

This is very easy now because now I can make this batch file available as short cut to other users as well.

Thanks a lot.

 

[Autoeng]

Glad I could be of assistance.

Autoeng