Security Problem!!

[saip15]

Where would be the best place to deploy the FE on the users computers? If I went with Documents and Settings would I use All Users or the specific user? All users only use the one computer in their office. I didn't know if it mattered or not where the FE was deployed dealing with security issues but they will have to log-in no matter what.

So I have to create a new shortcut for each deployment, correct? Yes, sorry.

Question about user groups: What is the point of having Read-only, Full Permissions, etc. optional user groups when everyone is apart of the Users group anyway? I set optional user groups and then gave the User group the default no permissions. The Users group overrides all of the permissions that are set for the optional user groups. How do you guys normally set your permissions? Manually?

Question about editing permissions: So I just logged onto a users computer as myself (admin) and changed the permissions for the database. Which .mdw file is affected by these changes? Should be the .mdw file that I have a shortcut to correct? Because I logged onto another computer and the permissions weren't updated. Thanks so much for you help guys!

What setting do I need to set so if someone is a form entering data and someone else tries to open it, they won't be able to and a message pops up?

 

[gemma-the-husky]

couple of things

Add another administrator with a password, before you remove admins from the admin group. otherwise you can NEVER sort this out.

NEVER NEVER modify system.mdw

 

[saip15]

Correct, Thanks gemma-the-husky!

 

[saip15]

Along with my other questions above, for some reason it seems like I have two different .mdw's. On a user computer there are different permissions than on mine. I have both shortcuts pointing to the same .mdw file on the network. How do I update the .mdw to be the same on all computers? Thanks

 

[SOS]

Along with my other questions above, for some reason it seems like I have two different .mdw's. On a user computer there are different permissions than on mine. I have both shortcuts pointing to the same .mdw file on the network. How do I update the .mdw to be the same on all computers? Thanks

The shortcut should be the thing that does it - it should be opening the database based on the MDW file you have referenced in the shortcut. So what is the shortcut's path currently?

 

[saip15]

"C:\Program Files (x86)\Microsoft Office\OFFICE11\MSACCESS.EXE" "Q:\Product Lines\BB\Saip\HW Database\Secure Test\Split Deploy\DBDeploy_FE.mdb" /wrkgrp "Q:\Product Lines\BB\Saip\HW Database\Secure Test\Security.mdw

I know I'm not supposed to use mapped drives but it is always the same, could this be the problem?

SOS, Could you please look at the other questions I had, I'm learning a lot and have been searching on those questions and haven't found an answer. I would greatly appreciate it.

 

[RossWindows]

I would avoid mapped drives like the plague.

As to your question: The best place to deploy the FE... Did you mean each user has their own computer, or there's only one computer and everyone uses it?

 

[saip15]

Each user has their own computer, as of right now I just have a folder (Database) directly under C:

 

[RossWindows]

That should be just fine.

One more thing you might want to do is keep the master front-end on the network and give each user a link to a batch file. What the batch file would do is copy the master front-end to the c:\Database drive whenever the user clicks on the link. This would allow you to make changes to the front-end and automatically deploy changes to the users without any intervention. I know there are plenty of links on the forum for ways to do this

 

[saip15]

Do you guys have any thoughts on what the problem might be with the .mdw file. I can make changes to the .mdw file on any computer and it will change everyones, correct? I really want to get that fixed because I don't want to keep guessing on which permissions are applied to which .mdw file.

 

[SOS]

Do you guys have any thoughts on what the problem might be with the .mdw file. I can make changes to the .mdw file on any computer and it will change everyones, correct?

NO, it won't. You change the mdw that is on the server where everyone links to it using the shortcut. You do not make changes to the mdw file on your machine. In fact you should not have a security.mdw file on your computer. You should have system.mdw and nothing else.

The security.mdw should be on the server where everyone can get at it. If others are on their computers then you would need to go into each and every one of the security.mdw files on all of the computers to change them. Everybody should be using the SINGLE security.mdw file. Does that make sense?

 

[saip15]

That's how i have it set up, sorry I didn't clearify. Like I stated in a previous post, I deployed the frontend and updated the shortcut to another computer and when I tried to log-in none of my permissions were set like I had them. I checked, and everything was pathed correctly, etc. Security.mdw. So I changed the permissions on the user computer. But when I came back to my computer the permissions had not updated and no changes were made to my computer. So the Security.mdw did not get updated.

 

[SOS]

Well, I'm stumped. I've tried everything I know in regards to this. Hopefully someone else can step in with some ideas.

 

[saip15]

That's fine! I'm going to start clean and re-split and set security. I have read through some recommended security articles, they cleared up some questions I had.

I had a question about a sample database that you created awhile back on tracking users. Would it be ok if I PM'd you with my question? Thanks again for all your help. I have learned so much!

 

[SOS]

Would it be ok if I PM'd you with my question?

Sorry, but I do not have PM's enabled.

 

[saip15]

Ok, On the sample track users DB, How do I disable the frmMain from displaying on start-up? I wanted to make sure I didn't mess anything up.

 

[SOS]

Ok, On the sample track users DB, How do I disable the frmMain from displaying on start-up? I wanted to make sure I didn't mess anything up.

In TOOLS > STARTUP you can change the drop down for Startup Form to NONE from the current one.

 

[saip15]

Right now I currently have my Switchboard that opens on start up. The frmMain still opens by itself. The start-up is set to none already on your database that you uploaded. Thanks SOS!

Q: After I use the shortcut to open my secure database, shouldn't the Security.mdw be the current .mdw under workgroup admin? Mine still has the System.mdw even after opening through shortcut. Is this right?

 

[SOS]

Q: After I use the shortcut to open my secure database, shouldn't the Security.mdw be the current .mdw under workgroup admin? Mine still has the System.mdw even after opening through shortcut. Is this right?

I don't currently have any secured databases to be able to check this out on. Perhaps you should go ahead and post that question as a new Thread in hopes of getting someone who does have one and can verify that for you.

 

[saip15]

Any idea on why the frmMain is still auto-starting? Thanks