Secure db over network

[TinMan]

"C:\Documents and Settings\Tom\My Documents\Databases\Transport Delivery.mdb"
/wrkgrp ""\\Server\company\Transport\Transport Delivery.mdb".mdw"

This is the target link on the shortcut i have pasted to our server but when
i log in as a custom user they can still change any permissions. What am i
doing wrong. Can anyone assist me please. Many thanks

 

[Arvin Meyer [MVP]]

First of all:

""\\Server\company\Transport\Transport Delivery.mdb".mdw"

should be:

"\\Server\company\Transport\Transport Delivery.mdb.mdw"

You have too many double-quotes. That's probably not your problem though.
Remember, severs have their own permissions as well. From your post, it
appears that you haven't set permissions on the back-end properly.
Typically, for a secure database, no one but the owner has any permissions
on the tables in the back-end at all. All queries are run with the:

WITH OWNERACCESS OPTION

set. This allows users to access data without having permissions on the
tables, and since all forms and reports should be based on queries instead
of tables, everything works. Have a look at the following security
information:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

You can thank the FTC of the USA for making this disclaimer necessary.

 

[Tom van Stiphout]

On Wed, 2 Dec 2009 02:44:01 -0800, TinMan

See my answer to your previous post.

-Tom.
Microsoft Access MVP

 

[Joan Wild]

You need the full path to msaccess.exe at the beginning of that target -
without it the /wrkgrp switch information is ignored. This means that
the default workgroup will be used. If your default is set to the
Transport Delivery.mdb.mdw (is that really its name - I have doubts
about the 'mdb' part), then you'll be OK.

However if your default mdw is set to system.mdw (which it should be),
then you have a problem because you shouldn't be able to even open the
secure mdb using system.mdw.

As Arvin indicated, you have too many quotes on the last path.

Joan Wild

 

[David W. Fenton]

"C:\Documents and Settings\Tom\My Documents\Databases\Transport
Delivery.mdb" /wrkgrp ""\\Server\company\Transport\Transport
Delivery.mdb".mdw"

Whatever the errors in this, it suggests that you have an MDB and a
workgroup file with the same name, stored in the same folder. This
will be disastrous, as the LDB file for both will have the same
name.

 

[TinMan]

Hi Joan and everyone else thanks for getting back to me on this. I tried
putting the target path to MS Access.exe and the path to the mdw file like
you say but when executing the shortcut it opens the main MS Access folder
and points to .exe file but that is it it stops there. I have split db's
front & Back, put BackEnd on server, front end on each machine and created
shortcut with following path -.Mdb

"C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"
"\\Server\Transport\Transport 09" /wrkgrp "\\Server\Software\System1.mdw.

Can you spot what i doing wrong. Sorry it taken so long to reply i am not
getting any notifications by email.

 

[TinMan]

Thank you David for posting. I changed the location of the mdw file which is
called system1.mdw, so my shortcut target path now reads

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" _ "C:\Documents
and Settings\Tom\My Documents\Databases\Transport 09"
"\\Server\Software\System1.mdw

Now Access is saying the command line in invalid.

 

[Arvin Meyer [MVP]]

This right here:

"\\Server\Transport\Transport 09"

doesn't point to the Access MDB file. If the above is the correct file
(Transport 09) it should be:

Transport 09.mdb

and there's an extra period at the end, which also lacks the closing quote.
So:

"C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"
"\\Server\Transport\Transport 09.mdb" /wrkgrp
"\\Server\Software\System1.mdw"

 

[Arvin Meyer [MVP]]

It is invalid. Assuming that everything is on 1 line, with a space between
each quoted section: You have an underscore which should not be there. You
are missing the file extension for Transport 09. You are missing the quotes
after the mdw.