Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    559

    Unanswered: Split DB on Network Drive

    I already split a db into, obviously, a front and back-end. I was wondering if there is a way that I can drop the back-end on a network share drive but NOT have the user see a 'network drive' in "my computer". Like make the connection each time they access the db but make the connection invisible to the user?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    If you link using a UNC path (\\ServerName\ShareName\FileName.mdb) the user won't see a network drive in My Computer. Further, if you hide that share when you create it (using $), they shouldn't be able to see it if they poke around through Network Places.
    Paul

  3. #3
    Join Date
    Aug 2006
    Posts
    559
    So I guess I'd have to do that through the command line? But will it reconnect each time?

    or do I have to put it into the actual coding within the db?

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I'm saying that when you link the tables in the front end, use that path rather than a mapped drive. You would need no code or anything on the command line. You don't need to reconnect unless the back end moves.
    Paul

  5. #5
    Join Date
    Aug 2006
    Posts
    559
    Ok, I'll try that.

Posting Permissions

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