how do i add workgroup to access 2007

[john smith]

I have a program I wrote in access 2000 I saved the workgroup file with it
how do I run this file in access 2007

 

[Allen Browne]

I have a program I wrote in access 2000 I saved the workgroup file
with it how do I run this file in access 2007

Create a shortcut that opens Access with this database and its workgroup
file.

The shortcut will need a target like this (as one line):
"C:\Program Files\Microsoft Office\Office12\masccess.exe"
"C:\data\MyFile.mdb" /wrkgrp "C:\data\system.mdw"

 

[Albert D. Kallal]

I have a program I wrote in access 2000 I saved the workgroup file with it
how do I run this file in access 2007

This works the same way it did before. You must FIRST join the workgroup
file, and THEN you can open the mdb file.

A better way (then changing the default workgroup file) is to specify the
workgroup file in your shortcut options.

"C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE"
"c:\program files\RidesXP\RidesXP.mdb"
/wrkgrp "c:\Program Files\RidesXP\Rides.mdw"

You can also run the workgroup administrator separately to join the
workgroup BEFORE you launch ms-access, but you likely don't want to do this,
as then for ALL access files you launch you get a password + logon prompt.

So, this works just like previous versions. If you convert the file to the
new accDB format, then workgroup security can't be applied (you only see the
workgroup options in the menu (ribbon) when a mdb file is opened, not for a
accDB file).