Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2004
    Location
    Regina, Saskatchewan, Canada
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts

    System.mdw (Access 2003)

    Hi! I have searched the posts and cannot find anything on my concern. If I have missed anything, I apologize.

    I have an accounting program called "Simply Accounting" that is based on MS Access and it has a security file (called XXX.sdw- the sdw is Simply Accounting's file terminology- as far as I can tell it is a .mdw file). I can access the accounting database, through MS Access 2003 but I have to go to Tools/Security/Workgroup administrator and join the "sdw" file first. When I want to access another MS Access database I switch back to the system.mdw file by going to the workgroup administrator and "joining" the system.mdw file.

    The last time I tried to join the system.mdw file I discovered there were now (in addition to the system.mdw file) a system1.mdw,a system2.mdw, etc. These files were not there before I started switching back and forth. Is this normal or have I totally messed up the files?

    Just before this happened, I downloaded a trial version of MS Office 2007 Professional but I have not used the 2007 version of access on these files.

    Any help, information that you can provide would be greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: System.mdw (Access 2003)

    Access probably created the .mdw files automatically since it doesn't really expect the .sdw file.

    You don't have to join a workgroup in order to use a secured database. You can create a shortcut that opens the database with the workgroup file without explicitly joining it.
    Set the target of the shortcut like this:
    <code>
    "C:Program FilesMicrosoft OfficeOffice11MSAccess.exe" "C:MyDatabasesMyAccounting.mdb" /wrkgrp "C:MyWorkgroupsSecure.sdw"
    </code>
    Substitute the correct path and filename for the database and for the workgroup file.

  3. #3
    New Lounger
    Join Date
    Jan 2004
    Location
    Regina, Saskatchewan, Canada
    Posts
    17
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: System.mdw (Access 2003)

    Thanks for your prompt response!

    I tried to be as prompt in thanking you but my company's system went down and has just now been reinstated.

    I was aware of the shortcut but I thought it wouldn't work in this case because I wanted to go into a database with a different name from the security file. But, as usual, the light went on as soon as I read your response. Duh!

    Again, thanks for the info!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •