Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Network" share on host PC not recognized.

Status
Not open for further replies.
WildHare

WildHare

MIS
Mar 1, 2002
1,801
US
Hi gang. Quick puzzler. A coworker set up a folder on his PC that he has shared with me. I have a database sitting in this folder (on his physical PC) that imports and exports stuff. My references to this folder use a network share syntax, e.g. "\\DMKT2C0002\MARKETING", where DMKT2C0002 is his maching ID on the network, and "Marketing" is obviously, the folder on his C:\ drive.

For example, "CONST NetDrive = "\\DMKT2C0002\MARKETING\"

Everthing is fine when I open the database and run the exports and imports, but when HE opens it, Access can't find any of the files - It claims not to recognize "\\DMKT2C0002\MARKETING\...." or find any of the files we import from.

WHen I changed the references to read "C:\MARKETING", it all worked for him (as I'd expect it to) but then doesn't work for me.

I don't see why his machine doesn't recognize his own network ID - am I missing something?

I checked the FAQs and archive search here, but found no particular resolution for this.

TIA

Jim


Me? Ambivalent? Well, yes and no....
Another free Access forum:
More Access stuff at
 
Sort by date Sort by votes
Hi,

Has he actually got this share mapped on his own PC?
I mean, if you open Windows Explorer on his machine, is it mapped to a drive letter?

(You will have it mapped on your PC - no?)

I don't even know if this is possible (couldn't check this as I'm at home) - i.e. mapping a share on your own PC.

I do know that with many applications sitting on our servers - errors occur because users don't have the share mapped to a drive letter.

Regards,

Darrylle




"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
 
Upvote 0 Downvote
He doesn't have it specifically mapped as another drive, per se. He just made a directory, and gave me access to it. I can find his machine on the network, and grab files there. I had mapped it, to start, as my "M:" drive, but when you hard code that in a shared application, it tends to screw up the other guy. So I converted what used to be

"M:\MARKETING\REPORTS\WEBSITE\blah blah blah"

to

\\DMKT2C0002\MARKETING\REPORTS\WEBSITE\blah blah blah


To him, it's just a folder on his C:\ drive. To Me, it's a mapped share.

But his computer doesn't recognize \\DMKT2C0002\...anything

Odd...

JMH


PS : we did this because our network admins, in their infinite wisdom, limit each user to just 120 MB of personal space on our shared network drive - and he/we filled it up about two weeks ago. There's some talk of buying another HD and chaining it on the network, but evidently the thought of anyone driving over to BestBuy and plopping down $80 for a 110GB Maxtor gives them the heeby-jeebies. :)





Me? Ambivalent? Well, yes and no....
Another free Access forum:
More Access stuff at
 
Upvote 0 Downvote
Hi,

Yep, so you're attempting to use UNC (\\machinename\shared folder) in code where he doesn't have this mapping - so he gets mucked up.

On the other hand: M:\MARKETING\REPORTS\WEBSITE\blah blah and it can't work on your machine because your machine has no such folder.

Your best bet is to use both, but dependant on user.

Have a look at CurrentUser() function - this may help.

Regards,

Darrylle


"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
 
Upvote 0 Downvote
Yeah, I'd considered that, but since there's no security on the DB, CurrentUser() will just show ADMIN for either/both of us.

I just find it curious that his machine doesn't recognise itself via the UNC name - what I may simply end up doing is setting a small function to be called as a startup option, and changing his shortcut to reflect this - so when he opens the db, I can trap that and make adjustments.

Thx for the input -

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:
More Access stuff at
 
Upvote 0 Downvote
Hi again,

Ok - I know that I've seen effective solutions in a Access forum on Tek-Tips that returns the machine name, and another that returns the network user login name.

Either would be just as effective (and just as simple to implement).

If I come across either on Tek-Tips (or any downloads I've made) I'll come back to this thread with it.

Regards,

Darrylle

"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk
 
Upvote 0 Downvote
Problem solved - I was able to MAP a drive letter on BOTH machines, the problem earlier was the Share Name that he used had a space in it - evidentally, Windows doesn't like you trying to map a share on your OWN PC that has a space in the name - but when we took the space out, it mapped fine. So we both refer to this folder on HIS PC as our X: drive, and all seems to be hunky dory...

JMH


Me? Ambivalent? Well, yes and no....
Another free Access forum:
More Access stuff at
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Split Function not working
Replies
3
Views
513
Kennelbloke
Kennelbloke
Moss100
  • Locked
  • Question
Access prompts "open or save" when I preview an excel file 1
Replies
1
Views
332
combo
combo
IrishJim
  • Locked
  • Question
How do I capture the "digital signature", for display in my Form header?
Replies
0
Views
336
IrishJim
IrishJim
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
607
strongm
strongm
DarkOne72
  • Locked
  • Question
Message Box Popup on certain days help !
2
Replies
23
Views
6K
Norman Sherlock
Norman Sherlock

Part and Inventory Search

Sponsor

Back
Top