UL Security (MDW) 2003 to 2007

[scratchtrax]

I'm sorry if this is a repeated issue and I just missed it, but I can't find
suggestions or solutions other than just "...don't upgrade yet". So, I will
ask and hopefully I won't be painfully dismembered peice by peice.

Just got new workstations at work today and they came with Office 2007. We
have in place an Access database that was built in Access 2000 and we were
running it the majority of the time in 2002 and we had established workgroup
security with the MDW file in order to use the db you had to log in with your
name and password. After the update I got the "...you do not have the
necessary permissions..." error message and the db would not open. I looked
around the help and I thought that in the A07 help it says that an older mdb
with security would be supported within A07. As I look around the threads
here (and in the general section) it seems like the mdw ULS went away with
the ACCDB file format and that it wont work within the A07 software. So,
which is it? Will it or won't it work within A07 if it remains an mdb? If
so, how can I open my file? If not, what would you suggest I do?

Assumting I cant go back to 02-03, my thoughts so far are either:

Go back to 03, remove the workgroup and ULS securtiy (if possible) and then
import and upgrade to 07-ACCDB. The problem there is that I have 00 and 02
users. Will they be able to open this format?

Or, again if possible, go back to 03, remove the workgroup (mdw) security
leave it in the mdb format unsecured and use the honor system until I can
figure out some sort of security for the mdb that will work with/for versions
spanning from 00 to 03. This is the way I'm leaning towards so far. I don't
think I really have too much to worry about as far as using the honor system.
At least I hope not.

I would be grateful for any thoughts or suggestions regarding this... I
think my first step is to do a search about how to remove the ULS and
workgroup security. If this isn't correct, please show me the way or even
just let me know your opinion. I am grateful for any assistance, even a link
to where I could read more about it, anything would really be great. Thanks
in advance.

Best Regards

 

['69 Camaro]

Hi.

So, I will
ask and hopefully I won't be painfully dismembered peice by peice.

We'd never do that to a fellow member of the Collective -- unless he needed
replacement parts. ;-)

After the update I got the "...you do not have the
necessary permissions..." error message and the db would not open.

_Always_ happens after an upgrade to a new version. It's because one is now
joined to the new version's default workgroup, which doesn't have any
security implemented. Stay joined to this default workgroup, but use a
Windows shortcut to open the secure database file with the secure workgroup,
so that the User ID and password prompt only appears for secure databases.
For instructions and the syntax (and one needs to be careful of the syntax,
or it won't work with any command line switches, such as /wrkgrp), please see
the tip, "How to open databases and only be prompted for User ID and password
for the secure databases," on the following Web page:

http://www.Access.QBuilt.com/html/security.html

I looked
around the help and I thought that in the A07 help it says that an older mdb
with security would be supported within A07.

Yes, but only as long as the format stays MDB. If it's converted to ACCDB,
the User-Level Security goes out the window, since ACE doesn't support it.
Only Jet does.

Will it or won't it work within A07 if it remains an mdb? If
so, how can I open my file?

Use the Windows shortcut that I wrote about earlier, and it will join you to
the secure workgroup for the current session when you authenticate.

Assumting I cant go back to 02-03, my thoughts so far are either:

Go back to 03, remove the workgroup and ULS securtiy (if possible) and then
import and upgrade to 07-ACCDB.

I wouldn't recommend that. Keep what you have.

The problem there is that I have 00 and 02
users. Will they be able to open this format?

No. However, with the Data Connectivity Components of the 2007 Office
System driver that can be downloaded from the following Web page, users can
connect to the tables and read the data from earlier versions of Access:

www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.

 

[scratchtrax]

Thank you for the response Camaro, but I must be thick or something...
within the link you sent it says "The syntax for such a shortcut would be:

""...<Full path to Office>\MSAccess.EXE" "<Full path to DB>\MyDB.MDB"
/wrkgrp "<Full path to secure workgroup>\Secure.MDW"

To rejoin the default workgroup, search for the "System.MDW" file on the
hard drive. There may be more than one of these files, but the default
workgroup file should be in the Windows System directory or in a directory in
the user's profile, depending upon the operating system. Use WRKGADM.Exe...""

I tried this and I still cannot open the db (get the same 'permissions'
error). I am the admin user and I do have a password. Within the link you
sent it says the Admin user (me and/or 'Admin') must not have a password set.
So, I am trying to remove this but I am now in 07 and can not find the
'WRKGADM.Exe' program...So...? Any further thoughts?

 

[Joan Wild]

You don't need to use the workgroup administrator (wrkgadm.exe) at all.
Just create a desktop shortcut using the format shown. Use the shortcut to
launch your mdb in 2007.
"path to 2007 msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

 

[scratchtrax]

So yes, I am thick.

Thank you both (Gunny & Joan) for going over this again with me. I did not
realize the paths should be concatenated together in the "Target" of the
shortcut with the last part separated by the "/wrkgrp"

BRAVO!!! And Thank you very very much!!