Emulate Network Drive

[TempestV]

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\sharename\backendname.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\sharename\backendname.mdb path.

Thanks. Phil.

[Larry Linson]

"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\sharename\backendname.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

[ManningFan]

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\sharename\backendname.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\sharename\backendname.mdb path.

Thanks. Phil.

[Arno R]

"ManningFan" <ma********@gmail.comschreef in bericht news:11*********************@h48g2000cwc.googlegro ups.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

[ManningFan]

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********@gmail.comschreef in bericht news:11*********************@h48g2000cwc.googlegro ups.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

[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********@gmail.comschreef in bericht news:11**********************@h48g2000cwc.googlegr oups.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********@gmail.comschreef in bericht news:11*********************@h48g2000cwc.googlegro ups.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

[ManningFan]

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.

[pietlinden]

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]

For the record, my hat size is "Medium".

[e-mail] 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.

[Arno R]

"ManningFan" <ma********@gmail.comschreef in bericht news:11**********************@e3g2000cwe.googlegro ups.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

[ManningFan]

That quote was GROUNDBREAKING...

A cure for cancer is useful. A quote from an irrelevant post is not.
Learn the difference, "Arno The Loser Who Tracks Down Old Posts".
Arno R wrote:

FYI: If I think it's useful I *will* track down old posts indeed.

[David W. Fenton]

"Larry Linson" <bo*****@localhost.notwrote in
news:geAQg.576$zi.260@trnddc01:

I don't know about mapping a local folder to a UNC name -- that'd
be a "platform" or "O/S" question, I guess.

Can't be done unless you name a machine on your home network with
the same name as the server and create shares accordingly.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/