Is UNC the My Network Places default?

[Lu An De]

Hi All,

If I'm relinking my FE to the BE(seperate mdb) tables using the Get External
Data/Link Tables method, and navigating via 'My Network Places', does that
make the embedded path UNC by default? I've read that a UNC path will be
quicker than a 'Mapped Drive'.

Is 'My Network Places' the same as 'Network Neighborhood'?

Lu An De

 

[Nikos Yannacopoulos]

Lu An De,

'My Network Places' and 'Network Neighborhood' are the same thing in
different versions of Windows. Browsing through 'My Network Places' will
indeed result in your links taking on the UNC path (you can verify by
looking at the patds in Tools > Database Utilities > Linked Table Manager).

I'm not sure the UNC addressing has a positive impact on speed, but it is
definitely more robust in that it does not rely on drive mapping, which a
user could change at anytime!

HTH,
Nikos

 

[Lu An De]

Nikos,

Thanks for your reply. I'm just trying to optimize a small multiuser app
which resides on an excrutiatingly slow network and any little tweak helps.
Added 'robustness' wont hurt either.

Cheers

Lu An De

 

[Brian]

Nikos,

Thanks for your reply. I'm just trying to optimize a small multiuser app
which resides on an excrutiatingly slow network and any little tweak helps.
Added 'robustness' wont hurt either.

Cheers

Lu An De

Your supposition about speed is possibly correct: using mapped drives can
cause desperate slowness in some circumstances. There are various articles
in the MS Knowledge Base.

 

[Arvin Meyer]

Another suggestion to improve network speed is to maintain a connection to a
linked table. I create a small 1 field, 1 record table and open it
immediately when I open the database. Something like:

Function MakeConnection()
On Error Resume Next
DoCmd.OpenTable "tblConnection"
DoCmd.MoveSize 5000, 3000, 200, 50
End Function

It will often increase form performance by 1000% (no kidding ... 10 times as
fast)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Lu An De]

Thanks Arvin,

Gotta give THAT a try!

Another suggestion to improve network speed is to maintain a connection to a
linked table. I create a small 1 field, 1 record table and open it
immediately when I open the database. Something like:

Function MakeConnection()
On Error Resume Next
DoCmd.OpenTable "tblConnection"
DoCmd.MoveSize 5000, 3000, 200, 50
End Function

It will often increase form performance by 1000% (no kidding ... 10 times as
fast)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

which will

 

[Tom Wickerath]

Also, see Tony Toews web page.

http://www.granite.ab.ca/access/performancefaq.htm


Tom
_____________________________________

Thanks Arvin,

Gotta give THAT a try!


_____________________________________

 

[±èÀǹ¬]

Also, see Tony Toews web page.

http://www.granite.ab.ca/access/performancefaq.htm


Tom
_____________________________________

Thanks Arvin,

Gotta give THAT a try!


_____________________________________

to times