Solved

Continue using workgroups in Access 2007, or something else?

Posted on 2010-08-18
10
297 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
10 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33465511
yes..the databases in Access 2002/2003 format will still work in A2010
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 

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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33466223
yes, i believe you can still use the workgroups in A2010
0
 
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 33487926
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

726 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