[AccessD] Access security

I second the move to SQL server.  Even using the free SQL Server Express
you can implement security to the data based on individual users or
setup roles for groups of people.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Tuesday, December 22, 2009 10:21 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access security

<< Now he wants to know what is.>>

 Move the data to SQL server and forget about JET.

Jim.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, December 22, 2009 9:19 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] Access security

A reader has asked about Access workgroups security and I told him the
truth -- won't keep out the determined, but a good security setup
nonetheless. Now he wants to know what is. I should've heard that
coming...

I'd like to hear thoughts on Access security and alternatives --
strictly opinion and war stories, you don't have to tell me how to use
it! ;)

Susan H. 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************