question

[Joe C]

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

 

[Keith Wilby]

Hello all,

When you set up security does it apply to every database on the computer?

Not if it's done right.

Can you make it specific to a particular database without it effecting the
other databases?

Papi

Yes, if it's done right. Have a look at the FAQ (link on my web site).

Keith.
www.keithwilby.com

 

[Joe C]

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 Wilby]

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

Did you read the FAQ? It's all in there. There's also an example on my web
site.

Regards,
Keith.
www.keithwilby.com

 

[Joe C]

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

 

[Keith Wilby]

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?

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?

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

 

[Joe C]

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