Re: How do I convert "System.mda" (Access97) to System.mdw ("Access200

You can't (use a system.mda).

Though the system.mda/mdw will open the db when both are converted to later,
you'll get "No permission on MSysAccounts". Anyway it's easy enough to check,
try altering permissions or something.

This appears to be a bug, but anyway it's a fact.

If you can remember all the PID's/WID you can just recreate a new mdw. If you
can't remember that, you'll need to desecure and start anew.

(if the system.mdw was created in A97, there is no problem, or not this
problem.)

There is some documentation in the SecFAQ, from memory it says "don't convert
mdw's!". There is documentation there on desecuring I think.

I'm sorry, it's not the answer you want.
Chris

"Bob Samborski" <Bob Samborski@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> I need to convert an Access 97 database (originally converted from a version
> 2.0 Access database) that has a workgroup file called "System.mda" which is
> the hub in which all my users' permissions are housed (user-level security).
> The conversion will be to Access 2003. I would like to upgrade the
Workgroup
> file to the latest version of "System.mdw," but I can't find any
> documentation on this. Can someone please help me?
>
> Thanks.
>


.

Relevant Pages

  • Re: How do I convert "System.mda" (Access97) to System.mdw ("Access200
    ... > 2.0 Access database) that has a workgroup file called "System.mda" which ... > The conversion will be to Access 2003. ... permissions are not stored in the mda/w; ...
    (microsoft.public.access.security)
  • Re: Dynamic volumes on WXPP SP2 make folder and file shares read o
    ... with the shares from WNT systems) on DEC Alpha) where the same shares had ... The permissions are the same as before the conversion to dynamic volumes. ... The permissions allow users of the Administrators and the System groups full ...
    (microsoft.public.windowsxp.network_web)
  • Re: Problem using ForeignToRTF32
    ... There are issues with permissions on ... not DCOM. ... and the conversion always works without a problem. ... exactly the same arguments to the routine from both programs. ...
    (microsoft.public.word.conversions)
  • Re: convert fat32 to ntfs question
    ... But note that conversion is a big step, ... FAT32 doesn't enforce user-based permissions, and NTFS ... afterward, or they might not run correctly, until the administrator ...
    (microsoft.public.windowsxp.basics)
  • Re: Dynamic volumes on WXPP SP2 make folder and file shares read o
    ... >>>I have converted the boot disk from basic partition to a simple dynamic ... >> gone wrong in the conversion process. ... > I have removed and recreated the permissions. ... >> the data from your backups you created before you started this process ...
    (microsoft.public.windowsxp.network_web)