Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 21st, 2004, 05:20 PM
Authorized User
Join Date: Apr 2004
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Use VBA to get data from Access (Share folder)

I have an Access db and need to get some tables from another Access db in a shared folder. I want to get the tables via VBA. I have the IP address of the location of the file. I was informed to use UNC (UNC ?).

Old April 21st, 2004, 06:23 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

UNC is like what I mentioned in my first reply:


You mentioned, in your earlier post that it was on a shared drive - which would mean it's mapped to X: or something like that.

connect to the X: not to or whatever it is.

If, for example, the file you have was located at
(that's the www.wrox.com IP)
But isn't what you want to connect to.
You don't even want to connect to

You need to be connected to the network that those are on.

so you'd actually be connecting to something like:
\\WroxWebServer\InetPub\wwwroot\dynamic\YourFile.m db



As I mentioned in my last post:

You need to know where the file is on your network - NOT the Internet

I am a loud man with a very large hat. This means I am in charge

Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing Network Share with Access VBA JonniP Access 15 January 5th, 2007 01:57 PM
hot access to a share folder in asp.net vsraja Excel VBA 0 June 5th, 2006 01:43 AM
how to share a folder or a file on the internt asimmehtab Pro VB 6 1 December 31st, 2004 07:38 AM
Use VBA to get data from Access (Share folder) ckentebe Access 6 April 28th, 2004 10:09 PM
how to share a folder mqnguyen Classic ASP Basics 2 August 6th, 2003 01:23 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.