Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mapping a shared drive On open of a form (Access 2000)

    Is there a way to map a network drive on the On Open event (or some other event) when a form is open. The drive mapping is sever1FS_ADM_Data_06$. Really in a bind here. Thanks..

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mapping a shared drive On open of a form (Access 2000)

    What exactly are you trying to do? If you know the UNC of the map, then you can use that all along. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mapping a shared drive On open of a form (Access 2000)

    The UNC is sever1FS_ADM_Data_06$. I need the user to map to this when they open the form. This where the main table for the form is located. Does this make sense?

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Mapping a shared drive On open of a form (Access 2000)

    Not really. Is the table in a database or is it some kind of external file? Is this the connect path for a linked table, or what? Access doesn't need mapped drives, it works just fine with UNC paths, so what you're trying to do isn't clear. Are you trying to bind the form to a file in that location? If so, it won't work. You can bind a form to a table or query or a stored procedure but not to a file.
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mapping a shared drive On open of a form (Access 2000)

    With the obvious questions of why you want to do this aside, here's how.

    net use T: MyServerMyShare

    Just make a string with that command and shell it.

Posting Permissions

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