Secured Access 2003 Using Access 2007

[javiernews via AccessMonster.com]

Hi,

I need to opened a secured DB with a new Work Group made in Access 2003 but
using now Access 2007


So,...... How Can I join or open a secured Work Group (MDW) made in Access
2003 but using now Access 2007 ????????

Thank you

 

[Joan Wild]

Create a desktop shortcut with a target of
"path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[javiernews via AccessMonster.com]

Ok , thank you very helpful !!

Problem is resolved, but is it any other way to open it without using
shortcuts ????????


Thank you !

 

[Joan Wild]

Yes you can join a workgroup in 2007, providing you are using the mdb format...

Database Tools...Administer...Users and Permissions
or from code
Docmd.RunCommand acCmdWorkgroupAdministrator

 

[javiernews via AccessMonster.com]

Thank you Joan !


With Access 2003 I can create a new Work Group and change (join) another Work
Group very easily by code or by Menu>> Tools >>> etc...


With Access 2007 I understand that is possible to change by code, but,........
.................I do Not think is possible to change (JOIN) to another Work
Group from Menu >> Database Tools >> Administer

Am I right ???????

Regards

 

[Joan Wild]

I don't have 2007 loaded, but my understanding is that you can join another workgroup - you must be using the mdb format (not the default accdb format).

 

[javiernews via AccessMonster.com]

Sorry but I do not think is possible, because Does Not shows any possible
button option on the Access menu.

You can Not join another WorkGroup using the mdb format, because on :
Menu >> Database Tools >> Administer , Does Not shows the menu, any
possible option to join or create a new WorkGroup.

Only possible to do it thought the Security assistant (User Level Security
Wizard) , but Not directly like Access 2003

Anyway thank you again for you replay

 

[Tom van Stiphout]

On Mon, 21 Jan 2008 10:23:17 -0500, "Joan Wild"

I'm under the impression you can use workgroup security (using the
/wrkgrp command line switch), but not create it.

Guys, the writing is on the wall. If you want to secure your Access /
Jet app, better use a different approach. Me, I'm going to check
membership of groups in Active Directory.

-Tom.

 

[Douglas J. Steele]

I assume you've seen what Microsoft has to say at
http://www.microsoft.com/technet/security/guidance/clientsecurity/2007office/default.mspx

There's also another alternative at
http://www.utteraccess.com/forums/showflat.php?Board=81&Number=1540366

 

[javiernews via AccessMonster.com]

Thank you Douglas & Tom !

I will check the provided information

Regards