linked table

[Boon]

Hello,

I have a question about how should I set the path for linked table.

I am using two computers (laptop and workstation). These two computers are
connected through my company's network. I have Access database "A" stored in
laptop and another Access database "B" stored in workstation. In database
"A", I have a linked table that links to a table in database "B". I link it
by using computer name (i.e. \\workstation\...\.\..). This works perfectly.
Now, I want to move the database "A" from laptop to workstation. So I just
copy and paste the file in to my workstation. The linked table still works
well. Note that now the 2 databases are stored in the same computer. My
question is: by linking table with a network path name, will it slow down
the processing time? Would it be benificial to change the path of the linked
table to local path (e.g. C:\data\.\.\....\)?

Thanks,
Boon

 

[Klatuu]

No. What you are using is known as a UNC path. UNC paths are preferrable to
drive map paths (G:\somefolder)
They are more efficient because they don't have to be resolved.
They are portable, as you are experiencing.
I always use UNC paths because in a multi user business environment, you
can't be sure all users will have the same drive mappings.

The only thing that can go wrong with UNC paths is if some network jockey
decides he wants to change naming conventions and start renaming stuff. That
only ever happened to me once time about 2 1/2 years ago. They expect him to
be released from the hospital soon, however

 

[Boon]

Thank you for your answer.

Boon

No. What you are using is known as a UNC path. UNC paths are preferrable
to
drive map paths (G:\somefolder)
They are more efficient because they don't have to be resolved.
They are portable, as you are experiencing.
I always use UNC paths because in a multi user business environment, you
can't be sure all users will have the same drive mappings.

The only thing that can go wrong with UNC paths is if some network jockey
decides he wants to change naming conventions and start renaming stuff.
That
only ever happened to me once time about 2 1/2 years ago. They expect him
to
be released from the hospital soon, however

 

[super3639]

Thank you for your answer.

Boon