Looking for some insight/suggestions....
Our application has used workgroups for security since it was built in Access 97 many years ago. Now that we're (finally) migrating to 2007, we're unsure as to whether we should continue using workgroups, or use some other means to secure the accdbs, which link to tables in a Sybase database containing confidential information.
We've gotten the workgroups to work fine in 2007, but we're concerned that workgroups will be de-supported altogether in Access 2010.
Does anyone have suggestions as to what we could use to secure the accdbs instead of workgroups? I'm reading up on Access 2007 security, but I'm not seeing a clear way to do this.
Or are we going to be safe, continuing to use workgroups, since they'll still be usable in Access 2010?