>Hi,
> Thank you for reply.
> How could I use DRIVETYPE() function to determine the network drive if i don't create any mapped drive in my client's pc? Hot to create mapped drive programmatically? Will it be better performance ti use mapped drive instead of \\server\c\ ??
>
>Thank you

I'm not totally sure what you're asking, so let me say this. First, simply being attached to a server, but not mapped, gives no indication of whether or not the user has any rights. FWIW, using the DISKSPACE() function with the UNC will attach you to the server, if you're not already. Again, however, this gives no indication of any valid information.

Further, I haven't been able to find a method of retrieving information on the currently attached, but not mapped servers. However, Ed Rauh has some programming available in the download section that might be able to do this.

As far as performance goes I would think that having a drive mapped might give better performance simply because the UNC doesn't have to be resolved. I haven't done any testing to confirm or deny this, however.