 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / April 2007How do I join another workgroup after updating to Office 2007?
After Converting a database file from Access 2000 to Access 2007 I can not find a way to join the workgroup file originally used for the database. It automatically uses the default system workgroup file. How can I join the correct workgroup file. Did you convert to the mdb or the accdb format in 2007? If the latter, security is 'no more' in accdb. It is still supported in the mdb format. If you're using the mdb format, you can change the workgroup via Database Tools...Administer...Users and Permissions or from code Docmd.RunCommand acCmdWorkgroupAdministrator The preferred method though, is to create a desktop shortcut that specifies the workgroup file to use "path to 2007msaccess.exe" "path to mdb" /wrkgrp "path to secure.mdw"  SignatureJoan Wild Microsoft Access MVP > After Converting a database file from Access 2000 to Access 2007 I can not > find a way to join the workgroup file originally used for the database. It > automatically uses the default system workgroup file. How can I join the > correct workgroup file. I am using the .mdb format. I did get this to work by creating a form with the code below. however, when I am trying to assign the workgroup in the properties of the shortcut it will not allow me the length of charecters I need to complete the path of the workgroup file. How can I get the shortcut to work while assigning the shortcut to the workgroup file? Thanks for your help. > Did you convert to the mdb or the accdb format in 2007? If the latter, > security is 'no more' in accdb. It is still supported in the mdb format. [quoted text clipped - 13 lines] > > automatically uses the default system workgroup file. How can I join the > > correct workgroup file. That's a limitation of a shortcut. Can you move either/both the mdb and the mdw higher in the folder structure and shorten their paths? SignatureJoan Wild Microsoft Access MVP >I am using the .mdb format. > I did get this to work by creating a form with the code below. however, [quoted text clipped - 30 lines] >> > the >> > correct workgroup file. I shortened the folder name and that allowed me enough character spaces. Thanks for your help. > That's a limitation of a shortcut. Can you move either/both the mdb and the > mdw higher in the folder structure and shorten their paths? [quoted text clipped - 33 lines] > >> > the > >> > correct workgroup file. This info helped me out GREATLY!! thanks. > Did you convert to the mdb or the accdb format in 2007? If the latter, > security is 'no more' in accdb. It is still supported in the mdb format. [quoted text clipped - 13 lines] > > automatically uses the default system workgroup file. How can I join the > > correct workgroup file. |
Reply to this Message |
 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.