Access DB setup

http://www.adobe.com/go/tn_14476

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"PaulTest" <webforumsuser@macromedia.com> wrote in message news:ghr6g4$6mo$1@forums.macromedia.com...
> Hello,
>
> I've walked thru de Dreamweaver article "Setting up an ASP development
> environment for Dreamweaver" successfully. However I get an error message when
> I want to view a simple database call.
>
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
>
> --------------------------------------------------------------------------------
>
> Technical Information (for support personnel)
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
> cannot open the file '(unknown)'. It is already opened exclusively by another
> user, or you need permission to view its data.
> /spxcrm/timetest.asp, line 9
>
> I have administrator rights.
> What could it be? I can't wait to get going with a nice application, but I'm
> stranded in the beginning. Please help me out here.
>
> Thanks,
>
> Paul
>
>

PaulTest wrote:
> Hello,
>
> I've walked thru de Dreamweaver article "Setting up an ASP development
> environment for Dreamweaver" successfully. However I get an error message when
> I want to view a simple database call.
>
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
>
> --------------------------------------------------------------------------------
>
> Technical Information (for support personnel)
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
> cannot open the file '(unknown)'. It is already opened exclusively by another
> user, or you need permission to view its data.
> /spxcrm/timetest.asp, line 9
>
> I have administrator rights.
> What could it be? I can't wait to get going with a nice application, but I'm
> stranded in the beginning. Please help me out here.
>
> Thanks,
>
> Paul

Paul, its not you who needs administrator rights, its the user account
that IIS uses that needs read/write access to the file/folder. Its
generally called iusr_computername (replace computername with your
computers name).

You will also find what once the file is in use by IIS, if you have the
file open and then IIS tries to access it, you may get the same error,
as you create a lock file which is hidden, that prevents IIS from
accessing it.

Dooza
--
Posting Guidelines
http://www.adobe.com/support/forums/guidelines.html
How To Ask Smart Questions
http://www.catb.org/esr/faqs/smart-questions.html

Have not done access since using text book examples but I recall having
that probem when I had Access open at the same time as DW.