long name vs short name

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Hi all,

I recently read (MSDN)that using short file name with access mdb
should improove performance on a network.

Anyone have experience with that?

Is it still relevant or was true with win98 only?

regards
 
Hi, Pierre.
Is it still relevant or was true with win98 only?
Click to expand...

It's still very relevant. Use the DOS 8.3 naming convention for all
directories in the path and the file name, without any spaces or special
characters, and the Windows API won't need to be accessed to resolve these
names. Also, put the file as close as possible to the root directory,
because the Windows networking API's are used to authenticate at every
directory level to ensure that Windows security permissions allow whatever
operations are required.

Using these two techniques will limit the use of time-consuming Windows
API's and will often noticeably speed up the operations of a networked
database.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)
 
Back
Top