Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Opening file on mapped drive problems...


24 Oct 2010   #1
MPD

Windows 7 32 bit home premium
 
 
Opening file on mapped drive problems...

I have five Windows 7 PC's networked together, two via Ethernet cables, and three via wireless to an Aximcom MR108-N router. Each PC has the same User Id and Password, and all belong to the same Workgroup. The network works most of the time, but that is not my issue. The router and all PCs are all fully patched to latest updates.

1. I use one of these PC's as the 'Master' PC because it contains an MS Access 2003 database file which is then accessed by each of the other four PC's.
2. I have set up a mapped drive back to this Master PC and this all works okay. Thus from each of the 'client' PC's I can open Windows Explorer and view the files on my mapped Z: drive.

My problem is that on each of these 'client' PC's I have a desktop shortcut to open MS Access and open the specific database file on the PC I have called the Master. Thus in my desktop shortcut properties form, the Target field on the Shortcut tab shows: "C\Program Files\Microsoft Office\Office11\MSACCESS.EXE" Z:\Data\Access\MyDatabase.mdb /x start_macro
The 'Start in:' field is: C:\Data\Access

When I first click on this desktop shortcut MS Access opens, then an error message pops up that it can't find the 'Z:\Data\Access\MyDatabase.mdb' file.

If I stay within MS Access, and try to open the file on the mapped drive manually - via clicking the [My Computer] button (within Access), then double-click on the Z: or mapped drive list entry, I get a small delay, then the list of files on that mapped drive appear. If I then cancel everything, and close MS Access, and try to start the desktop shortcut again, it all works perfectly!

Why do I have to use the File Open utility within MS Access to see the file I want to open, when I can already see it in the Windows Explorer mapped drive entry?

Why can't the file be opened the FIRST time from my desktop shortcut?

Is it a Windows permission issue, or what do I have to do to enable this file to be opened as soon as Windows has successfully mapped the drive?

I appreciate your help and answers.

...MPD


My System SpecsSystem Spec
.

Reply

 Opening file on mapped drive problems...




Thread Tools



Similar help and support threads for2: Opening file on mapped drive problems...
Thread Forum
mapped drive disappears after log out Network & Sharing
No Thumbnails for MAPPED Drive General Discussion
cannot delete mapped drive Network & Sharing
Mapped drive & USB drive letter conflict Network & Sharing
7 and XP file share though mapped drive Network & Sharing
Cant get rid of mapped drive Network & Sharing
How do I set up mapped drive for write? Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:54 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33