security and users?

[mattpearcey]

I am having trouble trying to set up the security for my database. I want there to be only two ways of viewing the database: either as the Administrator, or as a user (sales). So, how do i set these up? I have tried going through the wizards, and i think it has worked but then it alwasy shows logged in as admin. How do i get a screen to come up at the start, asking for username and password? Any ideas?

I know this is prety basic, but i can't get my head around it!?

Thank you for your help already.

Matt Pearcey

 

[gwinn7]

Hello, here are some ideas...

For securing your Access Tables:
In order to secure the database, try reviewing the following KB article at Microsoft.com: Q132143.

For securing your Acccess application:
You could compile and create and Access MDE. This will be separate from your back-end database tables. The compiled MDE version will prevent users from peering into source code, forms, etc and making changes.

To have access automatically open with a login screen:
You can click 'Tools' and then 'Startup' from the menu bar in Access and select your login form name from the 'Display Form' field. However, I would instead, create a startup macro called, "autoexec" that launches a function/sub you define in an Access Code Module. MS Access, by default will activate the macro named 'autoexec' to start your application. The sub or function would allow you to perform checks etc. prior to the user signing in when the code inside opens the form. You could use the 'Form_Load' event of the log in screen for this, but in my opinion, its not a proper use of that form.

Thats what I can offer in a brief nutshell. I hope it was helpful.

Gary
gwinn7

 

[mattpearcey]

Thanks Gary

The info is very useful. However, i have now downloaded an exe from the article you pointed me to. Ive yet to go through it, but im currently having a few probs trying to set up the user groups. It has told me to go through Wrkgadm.exe in windows/system. Will this be setting up a user group specifically for the database, or is it oignt ot have any bearing on usernames, etc of the network that i am on? Just a little confused?!

Thank you for your help already.

Matt Pearcey

 

[gwinn7]

If I recall the article correctly, the MDW is the file that WRKGADM.EXE modifies. The MDW is part of Access's security model. It is not part of your LAN configuration. It only affects Access users. Does this help?

Gary
gwinn7

 

[mattpearcey]

Yep - makes sense. I will work on it over the weekend, and come back if i have any more problems - which is highly likely! Thanks Gary Thank you for your help already.

Matt Pearcey

 

[mattpearcey]

im lost - i have ran the program and it has set up another database that all looks very confusing. How do get that to relate to mine, and in terms of the login screen do i creat the login form? And does this relate to the download, if so, how do i get ti to work? I think i may have confused myself by doing too much. Could you take me through it step by step? Sorry to be a pain, but i really need this to work well and not to be a half way effort by myself! Thank you for your help already.

Matt Pearcey