hi

  when am runing piece of code it says like this

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
---------------------------------
Error Type:
DAO.Workspace (0x800A0BEB)
The Microsoft Jet database engine cannot open the file 'c:\Inetpub\wwwroot\satyapro\db.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/satyapro/inc/common.asp, line 12
====
this is the original code

Const AppPath = "c:\Inetpub\wwwroot\satyapro\"
Const DBName = "db.mdb"
Const AvatarPath = "./avatars/"
Const EmoticonPath = "./emoticons/"
Const MainPage = "./index.asp"

it's working in other system ,am using windows xp sp2 ,it's working perfectly on win 98 pws

can u plz check this ,thanks in advance

sorry friends

the original code is missing in the above post
Dim DB, rsUser, rsMessage, rsTopic, rsForum, rsSection, rsSettings, rspMessage, UserCount, PostCount, TopicCount

'open the database
Set DB = CreateObject("DAO.DBEngine.36").Workspaces(0).Open Database(AppPath & DBName,,True)
Set rsUser = DB.OpenRecordset("User")
Set rsMessage = DB.OpenRecordset("Message")
Set rsTopic = DB.OpenRecordset("Topic")
Set rsForum = DB.OpenRecordset("Forum")
Set rsSection = DB.OpenRecordset("Section")
Set rsSettings = DB.OpenRecordset("Settings")
Set rspMessage = DB.OpenRecordset("pMessage")

Is that you are trying to browse this page keeping the mdb file open with access application? If so close the MDB and then try.

Cheers!

_________________________
- Vijay G
Strive for Perfection

hi

 am not trying to login to that form when the mdb is open ,am not at all touching that mdb ,but still it says it's opened i think it the problem with Dao engine ,

Hi,

Does the .mdb file have permissions set to allow the user
IUSR_[yourMachineName] to use it?

Cheers,

Chris