Some access tools

[casper_vdt]

Hello,

I was wondering if you can help me with some download links to some FREE access tools. I am looking for some tool in the security area, but any type of free access tool is welcome, you just don't know whene you're gonna need one.

Thanks

 

[SOS]

What kind of tool are you looking for in the "Security" area?

Some free Access tools:

MZ Tools
V-Tools
Headway Shortcut Builder
Smart Indenter

 

[SOS]

And Jeff Conrad's CSD Tools

 

[casper_vdt]

I need to have more then one users, and each user must have a security level......... exemple: user1 can add data into the table x using the x form, but user 2 ca modify all the records in table using the same x for, and user 3 can only view the data in the table.



and one more thing

a free tool like the package wizard (from developer tool extension) that has the option to use access runtime

 

[marianne]

uhuh ! what version is you ms access?

 

[casper_vdt]

Microsoft access 2003 with sp3

 

[marianne]

dont you have the package wizard on your access 2003, if not you can google it.

 

[marianne]

dont you have the package wizard on your access 2003? if not you can google it. and with regards to security, most probably all moderators here will suggest using the user level security.

 

[casper_vdt]

no I don't

dosen't the package wizard come with VSTO 2005 ?!?!

 

[marianne]

I see. I guess you can make use of 2007 runtime since its the updated version of ms access applications.

 

[Galaxiom]

Access 2007 supports user level security for 2000-2003 (mdb) databases but not for its new format (accdb). Probably a good idea to avoid using it in new designs.

Since users should only be interacting through forms it is relatively simple to implement your own security by disabling, locking or setting to invisible, any controls that should not be available below particular user security levels.

I test for the Windows username when the database is opened and lookup a user table for their security level which is stored as a Global variable. The value can be used to load a different switchboard form for different users.

At the form level extra features can be enabled to suit the security level when the form is loaded.

One tidy way to achieve this is to use the Tag propery of the controls. Set the controls to invisible (or disabled as preferred) and tag them with the security level where they should become enabled. Test this value against the current user's security level during the Onload event of the form.

Assuming numerically lower security level is higher security clearance:

Dim Ctrl as Control

For Each Ctrl In Me
If Ctrl.Tag >= UserLevel Then: Ctrl.Visible = True
Next Ctrl

Hide the 2007 Navigation bar (known as Access Window in earlier versions?).
I make an unhide button appear on the switchboard for developer level users.