long name vs short name

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
 
6

'69 Camaro

Hi, Pierre.
Is it still relevant or was true with win98 only?

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)
 

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