Solved

Continue using workgroups in Access 2007, or something else?

Posted on 2010-08-18
10
294 Views
Last Modified: 2012-05-10
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?

Thanks!
0
Comment
Question by:L_Malchiodi
  • 5
  • 3
  • 2
10 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33465383


"You should not convert your database if it relies on user-level security. As with replication, Access 2007 supports user-level security for .mdb databases, but not for .accdb databases. If your database application relies on user-level security to keep certain users from viewing or editing data or from changing the design of objects, or to change the way different users navigate in your application, you need to redesign the application before you convert to the new format."

from this link

Transitioning Your Existing Access Applications to Access 2007

http://msdn.microsoft.com/en-us/library/bb203849.aspx


see this link too
Security Considerations and Guidance for Access 2007
http://msdn.microsoft.com/en-us/library/bb421308.aspx

0
 

Author Comment

by:L_Malchiodi
ID: 33465486
Thank you....one quick question while I read these links. Will we still be able to leave these databases in Access 2002/2003 format when we migrate to Access 2010?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33465511
yes..the databases in Access 2002/2003 format will still work in A2010
0
 

Author Comment

by:L_Malchiodi
ID: 33465570
Hm...we're in kind of a bind, then.  We've already converted the databases containing the most code, and done significant development work in them.   We can't really go back at this point.   My mistake.

I think we're stuck with workgroups, then.   From what I'm finding around the web, it looks like they'll still work with 2010.....is that the case?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33466223
yes, i believe you can still use the workgroups in A2010
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
LVL 84
ID: 33473475
To be clear, so long as you have not converted to the .accdb format, your workgroup security will still work.

However, it would seem that you would use the security features of your Sybase database to provide data security. In that case, the only feature that Access ULS would provide would be a "navigation" type of paradigm. If that's all you're using ULS for (i.e. determining which user can open specific Forms, etc) then you can build a system that would mimic this.

The ONLY security feature in 2007/2010 is the database password. This is a much more secure password than older versions but I doubt it would do what you need (and it wouldn't protect your data at all).
0
 

Author Comment

by:L_Malchiodi
ID: 33487849
Thanks, we're going to stick with the workgroups, as they seem to work well for us with 2007, and provide the security we need.

Now for how to enable them in 2007.  For my own PC, I've done the command in the Immediate window in the Access VBA editor that allows you to bring up the workgroup administrator and join.     Our application is installed on customer PCs with Install Shield.   I understand that what the workgroup administrator is  just setting something in the registry.  Would either of you know what that would be, so we can have our InstallShield package make the necessary registry change?
0
 
LVL 84
ID: 33487912
I have no idea what you mean by this:

"I understand that what the workgroup administrator is  just setting something in the registry"

If you mean you want to launch the Workgroup Administrator, then just do this:

DoCmd.RunCommand acCmdWorkgroupAdministrator
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 33487926
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 33487934
see this link

http://office.microsoft.com/en-us/access-help/about-user-level-security-mdb-HP003070410.aspx

and expand

About workgroups and workgroup information files
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now