Creating A Database In MSSql 2000, But NOT In The Default Directory

I am trying to find a solution to a thorny problem I have encountered...

I am a newbie in Sql Server 2000, but have quite a bit of experience in databases, both on PC and mainframe.

I am currently writing a program, which needs, among other things, to create Sql Server databases, to be located NOT in the default Mssql2000 directory, but in the user's home directory.

I am using an ADO connection and trying to execute it, as follows:

The text of the relevant part of the program goes like this:

Dim strCreateDatabase As String
Dim MyCn As ADODB.Connection

Set MyCn = New ADODB.Connection

With MyCn
.ConnectionTimeout = 25
.Provider = "sqloledb"
.Properties("Data Source").Value = "MOP"
.Properties("Initial Catalog").Value = ""
.Properties("Integrated Security").Value = "SSPI"
.Open
End With

strCreateDatabase = "Create Database Rimon on (" _
& "Name = Rimon, Filename = '\mopusersMR_DiazsalpmsdataRimon_Data.mdf', " _
& "Size = 20, MaxSize = 100, FileGrowth = 5) " _
& "Log on (Name = 'Rimon', Filename = 'c:usersMR_DiazsalpmsdataRimon_Log.ldf', " _
& "Size = 2, MaxSize = 10, FileGrowth = 1)"

MyCn.Execute strCreateDatabase


Both the name of the Sql Server and the Win2K server is MOP.

All the directories exist, and I have full access to them.

When I try to run this command, I get the following message:

File
'\mopusersMR_DiazsalpmsdataRimon_Data.mdf' is on a network device not supported for database files.

When I omit this location, it works just fine.

If I run it on the server, using another directory, it works just fine.

Do you have any idea what I am doing wrong?

Thanks in advance for any help!
Rimon Rafiah