Hi All,
I have a front end / back end MS Access DB at my workplace. When linking the
front-to-back ends in the Linked Table Manager, I specify the network
location of the backend as \\servername\sh arename\backend name.mdb, which
works fine.
However, I want to do some development at home but I don't want to have to
keep re-linking the tables (this is time consuming as there's actually more
than one backend .mdb file). Is there a way I can emulate the network path
on my local (XP) PC? IE map a local folder to the
\\servername\sh arename\backend name.mdb path.
Thanks. Phil.
11  2085 
"TempestV" wrote
However, I want to do some development at home but I don't want to have
to
keep re-linking the tables (this is time consuming as there's actually
more
than one backend .mdb file). Is there a way I can emulate the network
path
on my local (XP) PC? IE map a local folder to the
\\servername\sh arename\backend name.mdb path.
There's code in the Developer Solutions sample database... see http://support.microsoft.com/kb/248674/en-us... that you can adapt, to
simplify the change. It is for a single backend MDB, but shouldn't be a
real problem to modify for multiple ones.
I don't know about mapping a local folder to a UNC name -- that'd be a
"platform" or "O/S" question, I guess.
Larry Linson
Microsoft Access MVP
You can write code to do the linking for you. Here at work we have a
form that shows all the development databases available, and all the
production databases available. We just choose which we want to link
to and press a button. The linking is all done in code, and it only
takes a moment. This way we can go from test data to field data and
back again when we need to test a new function or form.
TempestV wrote:
Hi All,
I have a front end / back end MS Access DB at my workplace. When linking the
front-to-back ends in the Linked Table Manager, I specify the network
location of the backend as \\servername\sh arename\backend name.mdb, which
works fine.
However, I want to do some development at home but I don't want to have to
keep re-linking the tables (this is time consuming as there's actually more
than one backend .mdb file). Is there a way I can emulate the network path
on my local (XP) PC? IE map a local folder to the
\\servername\sh arename\backend name.mdb path.
Thanks. Phil.
"ManningFan " <ma********@gma il.comschreef in bericht news:11******** *************@h 48g2000cwc.goog legroups.com...
You can write code to do the linking for you. Here at work we have a
form that shows all the development databases available, and all the
production databases available. We just choose which we want to link
to and press a button. The linking is all done in code, and it only
takes a moment. This way we can go from test data to field data and
back again when we need to test a new function or form.
Remember this one ??
"You spent more time posting useless information than it would have
taken to answer the question."
Arno R
I'd quote you, but I'm not so much of a loser that I'm going to go
looking for your posts.
Besides, it was useful for the OP to know it can be done. Which, I
believe, makes you SPNAK'D!
Arno R wrote:
"ManningFan " <ma********@gma il.comschreef in bericht news:11******** *************@h 48g2000cwc.goog legroups.com...
You can write code to do the linking for you. Here at work we have a
form that shows all the development databases available, and all the
production databases available. We just choose which we want to link
to and press a button. The linking is all done in code, and it only
takes a moment. This way we can go from test data to field data and
back again when we need to test a new function or form.
Remember this one ??
"You spent more time posting useless information than it would have
taken to answer the question."
Arno R
Well, I guess that makes you "Jagoff the SPNAKING Manning Fan...??" (again)
Hope you are glad with that title.
Arno R
"ManningFan " <ma********@gma il.comschreef in bericht news:11******** **************@ h48g2000cwc.goo glegroups.com.. .
I'd quote you, but I'm not so much of a loser that I'm going to go
looking for your posts.
Besides, it was useful for the OP to know it can be done. Which, I
believe, makes you SPNAK'D!
Arno R wrote:
>"ManningFan " <ma********@gma il.comschreef in bericht news:11******** *************@h 48g2000cwc.goog legroups.com...
You can write code to do the linking for you. Here at work we have a
form that shows all the development databases available, and all the
production databases available. We just choose which we want to link
to and press a button. The linking is all done in code, and it only
takes a moment. This way we can go from test data to field data and
back again when we need to test a new function or form.
Remember this one ??
"You spent more time posting useless information than it would have
taken to answer the question."
Arno R
I'm fine with that, as long as you're fine with "Arno The Loser Who
Tracks Down Quotes From Old Posts". Or we can just shorten that to
"Dick Breath". Whichever you prefer.
Arno R wrote:
Well, I guess that makes you "Jagoff the SPNAKING Manning Fan...??" (again)
Hope you are glad with that title.
ManningFan wrote:
I'm fine with that, as long as you're fine with "Arno The Loser Who
Tracks Down Quotes From Old Posts". Or we can just shorten that to
"Dick Breath". Whichever you prefer.
Arno R wrote:
Well, I guess that makes you "Jagoff the SPNAKING Manning Fan...??" (again)
Hope you are glad with that title.
Posts like this make me miss Don Mellon. At least he had a good grasp
on what he was talking about... Name calling? Wow. Act your age, not
your hat size.
For the record, my hat size is "Medium".
pietlin...@hotm ail.com wrote:
ManningFan wrote:
I'm fine with that, as long as you're fine with "Arno The Loser Who
Tracks Down Quotes From Old Posts". Or we can just shorten that to
"Dick Breath". Whichever you prefer.
Arno R wrote:
Well, I guess that makes you "Jagoff the SPNAKING Manning Fan...??" (again)
Hope you are glad with that title.
Posts like this make me miss Don Mellon. At least he had a good grasp
on what he was talking about... Name calling? Wow. Act your age, not
your hat size.
"ManningFan " <ma********@gma il.comschreef in bericht news:11******** **************@ e3g2000cwe.goog legroups.com...
I'm fine with that, as long as you're fine with "Arno The Loser Who
Tracks Down Quotes From Old Posts". Or we can just shorten that to
"Dick Breath". Whichever you prefer.
The quote was from a very recent post of you (only 2 days ago) ...
Apparently you don't know or (want to) remember what you post here ??
FYI: If I think it's useful I *will* track down old posts indeed.
Arno R This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Robert Tarantino |
last post by:
Hello,
I am trying to find a way to create a scheduled task or
service that will copy my local profile folders
under "Documents and settings" to a network drive. This
would allow me to restore my settings if my profile became
tampered with or corrupt. Is there any sample code
available out there?
-Robert
|
by: giloosh99 |
last post by:
Hello,
Im grabbing tables via VB code using visual foxpro ODBC drives.
The tables directory is in a mapped network drive. The code works fine
and does the job, however if the computer is idle for a while the
network drive apears to have a red X on the icon and the drive becomes
disconnected. this seems to effect the VB code from grabbing the
tables. I get an error saying the specific table cannot be found. If i
manually open the mapped...
|
by: Niloday |
last post by:
Hi All,
I am trying to access a mapped network drive from a service that I have
created.
The service needs to create/delete folders/files on a network drive. When I
tried to connect to a folder on mapped network drive (eg. N:\Storage that
corresponds to \\FS1NS\SharedDir\), I get an error as "Could not find part
of path N:\".
|
by: brian.oneil2 |
last post by:
Is there a way to install this onto a network file share and allow a
team to access it? I would say share a CD from a networked CD drive,
but there are multiple CD's that would have to be inserted.
TIA,
Brian
|
by: Lam |
last post by:
HI
anyone knows how can I open a mapped network file in C#?
I try string file = @"T:\file.txt"; it shows me the error: "Could not find
a part of the path"
but if I copy the file to my C dirve, and use @"C:\file.txt"; it worked
Thanks a lot
| | |
by: Nirosh |
last post by:
Hi All,
Can any one suggest me a best way to do this ..
I have a thrid party tool "EXE" that we need to use with our web service to
manipulate some complex XML files, which reside in a seperate files server.
we have mapped the fodler to a different folder and need to allow the EXE to
process on the mapped drive. When I trigger the EXE via web service the EXE
get the permission of the launching user (mean ASP.NET user) resulting a...
|
by: frostalicious |
last post by:
Used VB.NET (on my client PC) to convert VB6 executable
to .NET executable. Placed the .exe file on a network drive
on my server. From client, ran .NET Wizards "Trust an
Assembly" to make the .exe (on the network drive, on the
server) "Full Trust." From the client, double-click on the
..exe (on the network drive, on the server) and it runs fine.
So far, so good, but...
On the server, where I've installed not VB.NET but .NET
|
by: Barry Flynn |
last post by:
Hi
I am working with a VB 2005 program which has been converted from VB6.
It writes data out to a flat file, with code like the following line
WriteLine(riFileNo, "Hist", lsAssetID, lsRecordType, lsXNbr, lsFiscYr,
"Beg", CStr(H.BegBalAccDepn), CStr(H.BegBalCost), CStr(H.BegBalCostReval),
CStr(H.BegBalDepCost), CStr(H.BegBalDepnReval))
The program is running from within a Virtual PC
|
by: Phil |
last post by:
A file used by my application may be stored on a shared network drive, so
that it can be accessed by different people using the same application. I
have written some code that uses an OpenFileDialog to allow the user to
specify the location of the file (I then store the filename in the
registry). This all works fine from when the application is run normally,
but I would like to force the user to do this when the software is first...
|
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: 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: 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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
