I have a database, secured via a workgroup (mdw), which I
would like to be able to convert from Access 2000 to 97
and XP. However, it would appear none of the user accounts
specified in the workgroup actually have enough permission
to do this, as when I attempt to convert, I get a "the
current user does not have permission to convert or enable
this database", even after logging in to the mdw.

So, what do I need to do to the user permissions to be
able to convert the db sucessfully?

Any help would be greatly appreciated.

Create a shortcut that your users use to open the database with the /wrkgrp
switch. The general syntax is:

"FullPathToMSAccess.exe" "FullPathToDatabase.mdb" /wrkgrp
"FullPathToWorkgroup.mdw"

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



"Derek" <(E-Mail Removed)> wrote in message
news:096801c3720e$09edbdb0$(E-Mail Removed)...
> I have a database, secured via a workgroup (mdw), which I
> would like to be able to convert from Access 2000 to 97
> and XP. However, it would appear none of the user accounts
> specified in the workgroup actually have enough permission
> to do this, as when I attempt to convert, I get a "the
> current user does not have permission to convert or enable
> this database", even after logging in to the mdw.
>
> So, what do I need to do to the user permissions to be
> able to convert the db sucessfully?
>
> Any help would be greatly appreciated.

How much do you know about Access Security? If you are not comfortable
with it I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


"Derek" <(E-Mail Removed)> wrote in message
news:096801c3720e$09edbdb0$(E-Mail Removed)...
> I have a database, secured via a workgroup (mdw), which I
> would like to be able to convert from Access 2000 to 97
> and XP. However, it would appear none of the user accounts
> specified in the workgroup actually have enough permission
> to do this, as when I attempt to convert, I get a "the
> current user does not have permission to convert or enable
> this database", even after logging in to the mdw.
>
> So, what do I need to do to the user permissions to be
> able to convert the db sucessfully?
>
> Any help would be greatly appreciated.