Dan Waters
dwaters at usinternet.com
Tue Dec 11 16:14:41 CST 2007
You're right about password protecting the database of course. I was thinking of each person's individual password. Yes - I use API's too. Very Helpful! But for the purpose of this particular chart and its message, adding API's might have blurred the focus a bit. I strongly believe that so many IT folks have had to do 'Access Rescues', that by now my ability to find new potential customers has decreased substantially. So, I was glad to see that Access 2007 came out the way it has, so I can point out to IT folks at a potential customer that MS has recognized the problem and has taken steps to solve it. Thanks! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Tuesday, December 11, 2007 3:31 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 ULS (was: Access 2007 - Microsoftis justplain stupid.) First, they CAN create a database that is both password protected AND encrypted. In 2007 they merged those two abilities. So they aren't shying away from all security in Access. However, ULS provided user/role capabilities. With a passworded database, if you have the password, you have complete access. With ULS, your account and password only has the access granted by the admin. Second, on your skill set, you missed something I feel is another prime differential in skill set. APIs. I understand why you wouldn't include this in an Access skill set, but I would. Of course, I've always been somewhat of an odd goose when it comes to Access development. I started with just Access (97), and the more I learned about Access (both database and interface wise), the more I branched out. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, December 11, 2007 11:24 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access 2007 ULS (was: Access 2007 - Microsoftis justplain stupid.) I suspect that MS is doing this gradually. >From reading MS info on A2007, you cannot create a database in A2007 that uses ULS. You can convert a previous version database to A2007, and then A2007 will support ULS. But people can't, with only A2007, create a database which is password protected. For many or most companies that is a prerequisite for a 'critical' database. Last year I made a chart to help explain this. I think that MS saw the same 'red zone' that I see and wants to create a gap instead. That will separate casual users from people who are determined to be developers. And JC - notice that Classes are right up on top! http://www.promationsystems.com/PSI/Info/accessskillzones.htm Dan -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com