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 !

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