Security STILL an issue 3

[Daleen]

I designed a database at home and emailed it to work. At home I put security on it with User level, not with the wizard. I then put it on an NT server. There is NO security on it now, except at my machine. Everyone who has access to that folder can do anything they please. Yes, I obviously need help. From reading past FAQ's, I understand that using the wizard will take care of this. Is that true? This is the first time I have used 2000. Previously, I used 97 and was not too concerned about security, mostly because I didn't understand it. I also altered the menu on the database but the only thing that altered was my menu on my machine. No one else's. Where do I take security 101? Or can someone help me.
Daleen

 

[Daleen]

Terry, Sean, whoever,
I have read everything you sent me to and I tried Sean's approach on the shortcut. Nothing is working!! Do I need to go to each machine and set up the secuirty and ask IT to let me know if they do any reinstalls on access at any of these machines?
Daleen Our IT cannot help me, they do not know access.

 

[jacksonmacd]

Have you checked the "ownership" of the database. If it's owned by Admin, I think that you cannot lock Admin out of the database. Tools > Security > User and group permissions > Change Owner (tab)
Select the Database object.

You cannot change the ownership of the database, only the objects within the database. The only way to change ownership is to create a new database under the new owner's name, then import all the objects from the original database.

 

[tlbroadbent]

The only thing that needs to be set up on the user PCs is the command line to start Access using the correct workgroup file and database. You deploy the Workgroup file to a network location where everyone can access it. The set the /wrkgrp option on the command line to point to that file. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[Lightning]

Daleen

I modestly recommend my new faq FAQ181-1164. This might help, in conjunction with all the good advice you've received here.

HTH

Lightning