Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / January 2008

Tip: Looking for answers? Try searching our database.

Secured Access 2003 Using Access 2007

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
javiernews - 20 Jan 2008 08:48 GMT
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 - 20 Jan 2008 18:01 GMT
Create a desktop shortcut with a target of
"path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

Signature

Joan Wild
Microsoft Access MVP

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thank you
javiernews - 20 Jan 2008 22:25 GMT
Ok , thank you very helpful !!

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

Thank you !
Joan Wild - 20 Jan 2008 22:49 GMT
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

Signature

Joan Wild
Microsoft Access MVP

> Ok , thank you very helpful !!
>
> Problem is resolved, but is it any other way to open it without using
> shortcuts ????????
>
> Thank you !
javiernews - 21 Jan 2008 12:48 GMT
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 - 21 Jan 2008 15:23 GMT
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).

Signature

Joan Wild
Microsoft Access MVP

> Thank you Joan !
>
[quoted text clipped - 8 lines]
>
> Regards
javiernews - 21 Jan 2008 17:49 GMT
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 - 22 Jan 2008 03:44 GMT
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.

>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).
Douglas J. Steele - 22 Jan 2008 23:42 GMT
I assume you've seen what Microsoft has to say at
http://www.microsoft.com/technet/security/guidance/clientsecurity/2007office/def
ault.mspx


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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> I'm under the impression you can use workgroup security (using the
> /wrkgrp command line switch), but not create it.
[quoted text clipped - 8 lines]
>>another workgroup - you must be using the mdb format (not the default
>>accdb format).
javiernews - 24 Jan 2008 08:15 GMT
Thank you Douglas & Tom !

I will check the provided information

Regards
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.