Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-03-2019, 01:03 AM   #1
Zedster
Newly Registered User
 
Join Date: Jul 2019
Location: UK Warwickshire
Posts: 21
Thanks: 9
Thanked 0 Times in 0 Posts
Zedster is on a distinguished road
Linked table manager and UNC paths

I have a backend data file saved on a different server \\myserver\backend.

\\myserver\backend is mapped to K on my machine.

Currently I link to K but i would rather link to the UNC path.

Problem I have is in linked table manager even if I select the UNC path, it converts it to K.

How can I get it to link to the UNC path?

Zedster is offline   Reply With Quote
Old 07-03-2019, 01:35 AM   #2
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,768
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Linked table manager and UNC paths

do the table connection in code.

look at createtabledef


you might need to create the connect string, in which case, it needs to look like

;database=full-path-to-databasefile
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
The Following User Says Thank You to gemma-the-husky For This Useful Post:
Zedster (07-04-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing linked table paths OBBurton Modules & VBA 8 09-05-2014 05:54 AM
Changing Linked Table Paths sumdumgai General 2 02-11-2011 12:10 PM
Question Linked Table manager FoFa General 11 03-01-2010 01:14 PM
Linked Table Manager PaulO General 6 04-23-2009 01:49 AM
Linked Table Manager fenhow Modules & VBA 1 01-27-2008 09:32 PM




All times are GMT -8. The time now is 07:05 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World