linked table

B

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
 
K

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 :)
 
B

Boon

Thank you for your answer.

Boon
Klatuu said:
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top