As a company we have 2 sites and the same database is replicated at both sites
I link the tables from both these sites into my reporting database using linked tables.
The only problem I have is when I link some tables the link uses the mapping format Y:\ instead of the IP format \\192.239.14.11 5\.
Is there any way I can replace the Y:\ with the IP format in the Linked Table Manager as I can only use my reporting database on PC's where the correct IP Address is mapped to Y:
I'm hopping this will be easy I just can't see the soloution at the moment so if anyone knows it will be very helpful
7 5161 FishVal 2,653
Recognized Expert Specialist
Hi, Matt.
To the best of my knowledge, there is a straight way to do this.
In link wizard, when FileOpen dialog popups, type a full path with IP to the mdb.
\\192.239.14.11 5\......\SomeDa taBase.mdb
Regards,
Fish.
NeoPa 32,579
Recognized Expert Moderator MVP
Although I would never recommend using bare IP addresses in an address, the UNC (Universal Naming Convention) of a share is perfectly usable within linked tables.
UNC:
\\ServerName\Sh areName\Path\Fi leName
Fishval
Thank you will try this method next time this happens.
I figured out that if I set up my linked table by browsing through My computer it uses the drive letter but if I browse through My Netwok Places it uses the IP Address.
NeoPa
I do not know much about networks or naming conventions and the 2 files are not on servers we have peer to peer networking in both our offices with a VPN connection between LANS.
As they are not on servers should I use the PCName instead of ServerName and do you think the PCName will resolve back to the correct IPaddress at the other end of the VPN as is this not the job of a DNS server and we don't have one of these.
I'm a little out of my depth as I am using terms which I know very little about so please forgive any wrong understanding on my behalf.
Also I don't know if it makes a difference but i'm not using a public IP address it is a static ip address allocated to a pc within our network?
NeoPa 32,579
Recognized Expert Moderator MVP
Matt, I read through to the end and worked out where the periods (full-stops) should be ;)
You're talking along the right lines almost, but not quite. For UNC resolution you're using NetBIOS naming rather than DNS naming (although both resolve IP addresses to names). This is good news for you as this will mean that the PCName will almost certainly work for you (It does depend on network setup but I can't think of a situation where it wouldn't work).
ServerName refers to the PC serving the share - This is not necessarily a server, nor even one running a server version of Windows. You should be in luck there. Try it out and let us know how you get on.
I just tried ping -a then the IP address to find out the pc name, this did not work any ideas why? In the mean time I will get the pcname by telephone.
NeoPa 32,579
Recognized Expert Moderator MVP
The -a option (reverse lookup) will tend to work less reliably than the simple lookup option.
On my network I have DNS servers set up such that they return the name of a locally handled IP address. This is in my DNS system though. I don't recall how well (if at all) this works within NetBIOS/WINS systems. A remote system would be even less likely to resolve correctly.
PS. Make sure you test that the Ping of the given name does work (or at least a TraceRt if Ping responses are disabled on that PC (Firewall)).
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: David Gray |
last post by:
Hello all,
Having problems connecting to an Oracle 9i database from within
SQL/Server 2000 using the Security/Linked Servers feature.
Server1 (SQL/Server)
-----------
Windows Server 2003, Standard edition
MS SQL/Server 2000
Oracle 9i Client kit (OLEDB & ODBC) & Enterprise management tools
|
by: ziggs |
last post by:
I have a few DB's that I inherited. One Access database 97 is working
fine and on our network and is the front end to another access 97 db
within an unknown network folder. But, here's the question. When I
look in the table area, I see three linked tables. How can view the
link table and determine where the back end Access 97 is?
TIA
|
by: Bruce |
last post by:
Greetings!
After finally figuring out that the Linked Table manager is no longer
an add-in in Access 2003 I now discover that it does not display any
of my linked tables in the 'select linked tables to be updated' list.
Although I have about 30 linked tables in my application, absolutely
none of them are showing up in the list. I compacted and repaired,
but that didn't have any effect. Has anyone else seen this problem?
If so, how is...
|
by: Sam DeRT |
last post by:
Is there a way to hard code what a path to a linked table would be
without
going through the Linked Table Manager or a re-linking process?
My issue is that I'm installing a database with linked tables onto
several
different networks. I can pre-determine what each path will be, but I
can't
do the re-linking or the Linked Table Manager remotely for each
network.
|
by: Jill Elaine |
last post by:
I am building an Access 2002 frontend with linked tables to an
encrypted Paradox 7 database. When I first create these linked tables,
I'm asked for the password to the encrypted Paradox database, and the
linked tables are successfully created. I use the data from these
linked tables in several forms.
All works great until I close the Access frontend and open it again.
When I try to use the forms, I get an error message: "Could not...
| |
by: Parasyke |
last post by:
Can anyone guide me through changing the location of my linked tables
through the Linked Table Manager? (MS-Access 2000)
Here's what I've done:
I'm in the front-end application on a split database of course.
I open the Linked Table Manager, Select all Tables, and check "Always
Prompt for new location. This brings up a window which displayed the
possible sources which starts out as My Documents. I chose Network
Places and that brought...
|
by: JodiPhillips |
last post by:
Hi,
My first post! I've basically taught myself Access and the little I know about VBA through reading these forums and a couple of books.
I'm in the middle of a project at work - to put it mildly I've been thrown in at the deep end, in the past I've just done simple databases and that's been fine. Now, however I have to "roll out" various front ends to a single back end for initially 10 users (and the bosses have plans for this to go to...
|
by: franc sutherland |
last post by:
Hello,
I have a client who uses Access 97, but does not have the Linked Table
Manager. The system is split into front and back end.
Is it possible to install the Linked Table Manager into Access 97?
If not, how does one manage the table links?
Thanks,
|
by: prn |
last post by:
Hi folks,
Here's a weird one. We have a fair number of Access applications where the front end sits on a user's desk somewhere, but the data sits on a SQL server. We're in the process of retiring a SQL Server box that contains some of those databases and I've got the responsibility for the Access end of the changes. In most of the cases so far, it's been a matter of trotting over to the remote location and modifying the DSN (Control Panel >...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |