By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Querying Linked Tables on a Network Drive

P: n/a
Is there anywhere I can change a "Linked table's" source from the
network drive I mapped to the actual UNC Path???
The linked table manager lets you update it's locale, but I want to
input the actual UNC path so that other user's dont have to map the
network drive in the same fashion I have.

Mar 19 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You are thinking server based operations here. Access is a file based
system and does not provide a service like a server (sql server). This
means that Access must have a path to a file to link to where a server
only requires a connection string and the datafiles can reside anywhere.
One thing you could try is to use an ODBC connection. You can create an
ODBC datasource in Control Pannel/Administrative tools, and now a
backend datafile can reside anywhere on the network. The downside is
that you have to add the ODBC datasource to each workstation that needs
to access the backend data.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
Mar 19 '07 #2

P: n/a
Rich P wrote:
You are thinking server based operations here. Access is a file based
system and does not provide a service like a server (sql server).
This means that Access must have a path to a file to link to where a
server only requires a connection string and the datafiles can reside
anywhere. One thing you could try is to use an ODBC connection. You
can create an ODBC datasource in Control Pannel/Administrative tools,
and now a backend datafile can reside anywhere on the network. The
downside is that you have to add the ODBC datasource to each
workstation that needs to access the backend data.

Rich

*** Sent via Developersdex http://www.developersdex.com ***
You cannot use ODBC Access-to-Access.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Mar 19 '07 #3

P: n/a
pa****@gmail.com wrote:
Is there anywhere I can change a "Linked table's" source from the
network drive I mapped to the actual UNC Path???
The linked table manager lets you update it's locale, but I want to
input the actual UNC path so that other user's dont have to map the
network drive in the same fashion I have.
Use the linked table manager but browse to the BE location by going through
Network Neighborhood - Entire Network. That will give you a UNC based link.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Mar 19 '07 #4

P: n/a
paquer,

I'm assuming you're asking about linking another Access database. Have you
tried using the UNC convention in the file dialog?

\\MyServer\ServerShare\CompletePath\MyDB.mdb

-- Bill

<pa****@gmail.comwrote in message
news:11*********************@l75g2000hse.googlegro ups.com...
Is there anywhere I can change a "Linked table's" source from the
network drive I mapped to the actual UNC Path???
The linked table manager lets you update it's locale, but I want to
input the actual UNC path so that other user's dont have to map the
network drive in the same fashion I have.

Mar 19 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.