Password protection with Database will not work

[kvoguy]

Hello,

I want to use a password on my access database. I set the password with open exclusively.

Now in my include file I wrote this...
<%
set objConn = Server.Createobject(&quot;ADODB.Connection&quot
objConn.ConnectionString = &quot;Provider=Microsoft.Jet.OLEDB.4.0; user id=; password=***; Data source=&quot; & Server.Mappath(&quot;..\helpdesk\db\ict.mdb&quot
'objConn.Mode = 3 '3 = adModeReadWrite
objConn.Open
%>

When I try to run it in IIS I got this errormessage:
--
Microsoft JET Database Engine (0x80040E4D)
Kan de toepassing niet starten. Het gegevensbestand van de werkgroep ontbreekt of is exclusief geopend door een andere gebruiker.
/ictonline/includes/openconnection.asp, line 6
--
I from Belgium so I got a dutch explanation. I try to translate...
Cannot start the application. The systemfile of the workgroup is missing or is exclusively opened bij another user.

I hope this is enough to help me with this problem.
I'm sure the database is not in use.
also my includefiles are working, cause without password it works fine.

Thanks in advance

 

[mwolf00]

You say that the DB is working fine w/o the password. When you add a password, are you having any problem with Access itself, or only when you try to connect via asp?

That is the error I usually get when I have the DB open while I'm developing. Sometimes I forget to close the table design view and I get that error.

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[kvoguy]

I'm sure the database is closed.
other suggestions?
thanks