Recent content by kurtwjohn

Try this. 1) Open access and create a new workgroup file (something.mdw) with a name other than system.mdw. Don't create or open a database yet - just stay in the main Access window. Use Tools>Security>Workgroup Administrator to create the new workgroup file (something.mdw) and put this file...

was finally able to secure the data base. I used a combination of the paper referenced above regarding creating a new owner and using the security wizard as Microsoft had suggested. I tried one solution then the other, but neither one alone locked out a user accessing the db directly (not going...

was finally able to secure the data base. I used a combination of the paper referenced above regarding creating a new owner and using the security wizard as Microsoft had suggested. I tried one solution then the other, but neither one alone locked out a user accessing the db directly (not going...

Len, Thank you. I have gained so much help from this forum that I was glad to offer something in return. Kurt

I was finally able to secure the data base. I used a combination of the paper referenced above regarding creating a new owner and using the security wizard as Microsoft had suggested. I tried one solution then the other, but neither one alone locked out a user accessing the db directly (not...

I also found this link with pretty good documentation, which appears to address what I think is going to be the solution (towards the end of the document). I think the problem is that I was logged in as the "generic" Admin owner when I created the database instead of following the instructions...

mafhobb, Yes. Please send it to me. I'll take a look at it. If it's from this forum, I may have already read it. But you never know. I did speak with the Microsoft support person today. He said that I needed to use the wizard to setup the security. I tried it, but it didn't solve my problem...

Thanks for your feedback. I do use the command line within a desktop icon to point to the custom.mdw file, which resides in the same network folder as the customer.mdb data base. I don't know if I was pointing to the default system.mdw file at the time when I setup the security or not. It's not...

I am searching this exact same issue. I have a db on the network with the mdw file in the same network folder. As long as the user uses the icon I provide with the db and mdw locations configured everything works well. But if they open Access first and then navigate to the data base it opens...

Thanks for responding so quickly. I have setup a couple of super users with both Admin and User Groups assigned. I had deleted Admin Group from the Admin user, but I couldn't delete the User Group ... Access 2003 won't let me. But the User Group has no permissions. So, I figured that was ok. I...

I thought I had the security figured out. I setup user level security for a multi-user data base that works great. Users only get to do what their user group has permissions for. Then someone who had access to the network folder, but wasn't setup with a user id and password installed Access...

I've been reading the forum for a couple of days on security and WIF and testing before adding this functionality to my data base. I've been "practicing" on a test data base and have a quick question. How do I create a WIF file tied to a specific data base. When I access "Workgroup...