User log in

[Dave]

Access 2007

I want to add a user login to my Access 2007 file.
Users will have to present a username and password and depending on their
what they enter will have certain restrictions on what they can access.

I understand that this was a built in functionality in Access 2003 that has
been removed in Access 2007.

I have also heard that the easiest way to do this is convert my DB to 2003 -
add the user security and then convert back to 2007.

This DB is not so complicated so I believe this conversion process would
probably not break anything.

So - 2 questions

How do I add user security in 2003? A link to a good tutorial would be
great.


How do developers approach this in 2007?

OH! One more related comment. This can NOT be based upon machine/windows
login as several users may us the same machine and despite my insistence
that there be a Windows login, that was rejected.

Any help here will be appreciated.

Thanks in advance


Dave

 

[Joan Wild]

You can convert to 2003 and leave it in that format. 2007 can use it fine.

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm

Regarding your last comment, I assume the Windows login might have been
rejected because folks didn't want to have to login/out all the time. What
makes you think that they won't just login with one user's name and leave it
for everyone to use?

 

[pddxxx]

There are many alternatives to using Access Security when it comes to
securing your database.

A shareware version of a simplified user security add-in that I've
written - LASsie (Light Application Security) for MS Access - is
available for download here:
http://www.peterssoftware.com/las.htm

Also, there's the Access Project Security Manager from
databasecreations, Inc.:
http://www.databasecreations.com/prod_apsm.htm

Hope this helps,

Peter De Baets
Peter's Software - Microsoft Access Tools for Developers
http://www.peterssoftware.com

 

[Dave]

Joan,
That's for the detailed steps.

I will look it over

Dave

PS: You are right about leaving the application open.
Is there any way to code a "Timeout"?

 

[Dave]

Peter,

I am going to look at your software solution.
I want to make sure I understand the pricing.

The will be for a single application in a multi-user enfironment.
Would that be a "Single Application License"?

Also does this install to "A" computer or to "THE" application
From you site "instructions on the screen to install this application on
your computer"

How difficult to configure?

Thanks

dave

 

[Douglas J. Steele]

http://support.microsoft.com/kb/210297

Don't worry that it says Access 2000: it works in all versions.

 

[pddxxx]

Dave,

My comments are interspersed below...

Peter,

I am going to look at your software solution.
I want to make sure I understand the pricing.

The will be for a single application in a multi-user enfironment.
Would that be a "Single Application License"?
Yes.


Also does this install to "A" computer or to "THE" application
From you site "instructions on the screen to install this application on
your computer"

It installs to a computer. The shareware/Single Application License
version of LASsie must be installed on each end-user's computer. We
also offer an unlimited, royalty-free distribution license with source
code version that does not require additional installations.

How difficult to configure?

Much easier than Access User Security! But it is intended to be a
simpler security system. Feel free to try it out. The shareware
version can be downloaded at this link http://www.peterssoftware.com/las.zip

Thanks

dave

Hope this helps,

Peter De Baets
Peter's Software
http://www.peterssoftware.com

 

[pddxxx]

PS: You are right about leaving the application open.

Is there any way to code a "Timeout"?

We have a free tool to help shut down applications after a period of
inactivity: Inactive Shut Down Control: http://www.peterssoftware.com/isd.htm

Hope this helps,

Peter De Baets
http://www.peterssoftware.com