Recommendation: system process using a mapped drive

Mapped drives
UNC path
My Setup: Server A: Win2k / Access2000 Server B: Win2k3 / Access2007 I have a syncing application that will look for changes on my ServerB database, and replicate those changes to the ServerA DB. This application is based around a mapped drive. What I am trying to secure is a method that will work without user interaction. If I log into the console, map a drive, and initiate, it works fine. But what if the machine crashes/reboots/etc. What is the best method to gain access to a network share from a process run by the system, not a user? (I have mapped using Explorer, command line, and a WSH script… but is there a method that is better for my needs?) TIA~ Dave

Answer Wiki

Thanks. We'll let you know when a new response is added.

Can’t you set the application to run across a unc path? Instead of looking at X:\data_source\data.db, can’t you set the app to look at \\serverB\data\data.db.

The best method is to not use a mapped drive as there is no way to guarantee that the mapped drive will always exist. The best method is to use the UNC path to access to remote access database.

And I must say, writing a data replication system in Microsoft access, that’s pretty hard core. I’m curious why you decided to stay in Microsoft access, instead of scaling up to Microsoft SQL Server Express which includes a very robust replication system?

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • DaveLockard
    I used access simply because the office staff uses an access based forms dirven application to manage the company. This was a web application that plugs into. The app developer wanted to keep the Lan app of the internet; we devised a warehouse that holds the stored web data... and reconcilliation occurs between the two. The most stable method I use so far is a batch file the uses the 'net use' line, passing my parameters. The failure is the batch is used at logon or startup; It is an utter failure if the machine reboots or crashes and no one is there to open the console.
    50 pointsBadges:
  • Mshaich
    I solved this for myself by creating a batch file that maps a drive to a NAS and using the scheduled tasks to run the batch file under the system context when the server boots. Batch file mountmapped.bat: echo %date% %time% : "%cd%mountmapped.bat" >> e:tempmount.log net use M: \ / password >> e:tempmount.log 2>&1 2>&1 In Scheduled Tasks: Run: e:mountmapped.bat Start in e: Run As: NT AuthoritySystem Schedule:At System Startup This allows a service I have to use the M drive as the service runs under the system account also.
    10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: