Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 21st, 2004, 05:20 PM
Authorized User
 
Join Date: Apr 2004
Location: Toronto, Ontario, Canada.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default Use VBA to get data from Access (Share folder)

Hello,
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 ?).
HELP !


Reply With Quote
  #2 (permalink)  
Old April 21st, 2004, 06:23 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

UNC is like what I mentioned in my first reply:

\\server\share

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 192.168.1.1 or whatever it is.

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

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

or

X:\dynamic\Yourfile.mdb

As I mentioned in my last post:
FORGET ABOUT THE IP ADDRESS - YOU DON'T NEED IT

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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 05:02 AM.


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