I had wrote a dll which will generate xml in a xxx.asp file (using msaccess xxx.mdb file). However, when the database file is located in a network driver it fail to open it. The encode is:
Set dbConnection = New ADODB.Connection
Application("wsr_db_ConnectionString") = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=S:\abc.mdb;" & _
"Persist Security Info=False"
The error message is :
Error Occur in gm0101.gx0101() : -2147467259:The Microsoft Jet database engine cannot open the file 'S:\eSales.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
The IIS PC's OS is win2k pro and the network driver is a win98 pc. Both PC's file system are FAT32
I don't know why it claim that it is access control issue?
Thanks for the one who can help me!