Querying Linked Tables on a Network Drive

[paquer]

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.

[Rich P]

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 ***

[Rick Brandt]

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

[Rick Brandt]

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

[AlterEgo]

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.