question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

When you set up security does it apply to every database on the computer?
Can you make it specific to a particular database without it effecting the
other databases?

Papi
 
OK, so my question now becomes how does one secure a database with end user
type premissions over a small network?

Thanks
Joe
Papi
 
Keith,

That was an tremendous help. I have a couple of quick follow up questions.

I am unclear of this (Your users will need to use desktop shortcuts to
switch their PCs to your workgroup and release it afterwards:)

I understand what needs to be done but I don't understand the mechanics of
it all. I can create the shortcut to the file but it looks like some sort of
batch file that does three things. Is this correct?

What role does the network administrator have in this process?

Thanks.

Joe
Papi
 
Joe C said:
Keith,

That was an tremendous help. I have a couple of quick follow up questions.

I am unclear of this (Your users will need to use desktop shortcuts to
switch their PCs to your workgroup and release it afterwards:)

I understand what needs to be done but I don't understand the mechanics of
it all. I can create the shortcut to the file but it looks like some sort
of
batch file that does three things. Is this correct?
Click to expand...

Not sure why it would look like a batch file. You just need an ordinary
shortcut with the command line as stated in the example, including quotation
marks:

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"x:\Path\MyDatabase.mdb" /wrkgrp "x:\Path\MyWIF.mdw"

The first part opens Access, the second defines the path to your app and the
third to your security file. The alternative would be to have your users
permanently joined to your workgroup but then they'd be prompted to logon
even to unsecured databases.
What role does the network administrator have in this process?
Click to expand...

They need play no part at all but your users need read/write/execute/delete
permissions to the host folder. Your network admin will have to set that up
if it isn't the default and/or if you don't know how.

HTH - Keith.
www.keithwilby.com
 
Keith,

Again thank you for your efforts. It is helping a great deal.

Before I begin the search I want to ask for your direction on this next
topic. Within the security mode I need to see who within my stable of users
has editied a record. I would love for that to be a visable field on any
given form. Where would I go for the best direction?

Thanks again
Joe
Papi
 
Back
Top