I'm having some difficulty in establishing a DB connection in the Movie2000

example from Beginning ASP 3.0.  When I use the code provided in the book, I

receive the following error message: 



<!--Begin Error Message-->

Microsoft JET Database Engine error '80004005' 

The Microsoft Jet database engine cannot open the file

'filepath\movie2000.mdb'. It is already opened exclusively by another user,

or you need permission to view its data. 

/WEI/Sandbox/Database/connect2.asp, line 22

<!--End Error Message-->



The DB is not in use by anyone else and the folders all have the proper

permissions set.  If someone could provide me with a checklist of potential

problems that I can go through, I would be most appreciative.

Thank you!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: I'm having some difficulty in establishing a DB connection in the

Movie2000

: example from Beginning ASP 3.0.  When I use the code provided in the book,

I

: receive the following error message:

:

: <!--Begin Error Message-->

: Microsoft JET Database Engine error '80004005'

: The Microsoft Jet database engine cannot open the file

: 'filepath\movie2000.mdb'. It is already opened exclusively by another

user,

: or you need permission to view its data.

: /WEI/Sandbox/Database/connect2.asp, line 22

: <!--End Error Message-->

:

: The DB is not in use by anyone else and the folders all have the proper

: permissions set.  If someone could provide me with a checklist of

potential

: problems that I can go through, I would be most appreciative.

: Thank you!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



You say that you have "the proper permissions set" - are you sure? What

permissions do you have set for the .mdb file, and for the folder that the

.mdb file is in.



Cheers

Ken

Folder permissions --> Everyone Full Control



DB Permissions --> Under Tools > Security > User and Group Permissions:



Everything that is not greyed out is checked.

I assume the file is on an NT machine?



If so have you checked to see if the system shows the file in use, this can

sometime occur when your building as ASP page and it connects to the db and

leaves the connection open but the page quits with errors. You could also

check to see if there is a lock file present which would indicate, as far as

the system goes, that the file is in use....



Just a thought...



-----Original Message-----

From: Levensailor Aaron A.

[mailto:alevensailor@w...]

Sent: Monday, March 12, 2001 2:02 PM

To: ASP Database Setup

Subject: [asp_database_setup] Access connection error - Movie2000





I'm having some difficulty in establishing a DB connection in the Movie2000

example from Beginning ASP 3.0.  When I use the code provided in the book, I

receive the following error message: 



<!--Begin Error Message-->

Microsoft JET Database Engine error '80004005' 

The Microsoft Jet database engine cannot open the file

'filepath\movie2000.mdb'. It is already opened exclusively by another user,

or you need permission to view its data. 

/WEI/Sandbox/Database/connect2.asp, line 22

<!--End Error Message-->



The DB is not in use by anyone else and the folders all have the proper

permissions set.  If someone could provide me with a checklist of potential

problems that I can go through, I would be most appreciative.

Thank you!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: Folder permissions --> Everyone Full Control

:

: DB Permissions --> Under Tools > Security > User and Group Permissions:

:

: Everything that is not greyed out is checked.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



What about NTFS permissions for the actual file itself? (not the folder?)



Also, is there a .ldb lockfile present? It may be that you have some left

over connections that you are not closing in your code?



Also are you connecting with the correct username/password?



You don't happen to have the DB open anywhere else (eg in Access? or in

Visual InterDev?)



Cheers

Ken

I have exactly the same problem myself. I use a clean new install of 

Win2000 and IIS and i have all settings like the above user. The db is 

definately not used by anyone and permissions are all set corectly. We 

need new ideas about this problem.!!!



Nick



> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> : Folder permissions --> Everyone Full Control

> :

> : DB Permissions --> Under Tools > Security > User and Group Permissions:

> :

> : Everything that is not greyed out is checked.

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> 

> What about NTFS permissions for the actual file itself? (not the folder?)

> 

> Also, is there a .ldb lockfile present? It may be that you have some left

> over connections that you are not closing in your code?

> 

> Also are you connecting with the correct username/password?

> 

> You don't happen to have the DB open anywhere else (eg in Access? or in

> Visual InterDev?)

> 

> Cheers

> Ken

> 

> 

I assume the file is on an NT machine?



If so have you checked to see if the system shows the file in use, this can

sometime occur when your building as ASP page and it connects to the db and

leaves the connection open but the page quits with errors. You could also

check to see if there is a lock file present which would indicate, as far as

the system goes, that the file is in use....



Just a thought...



-----Original Message-----

From: Levensailor Aaron A.

[mailto:alevensailor@w...]

Sent: Monday, March 12, 2001 2:02 PM

To: ASP Database Setup

Subject: [asp_database_setup] Access connection error - Movie2000





I'm having some difficulty in establishing a DB connection in the Movie2000

example from Beginning ASP 3.0.  When I use the code provided in the book, I

receive the following error message: 



<!--Begin Error Message-->

Microsoft JET Database Engine error '80004005' 

The Microsoft Jet database engine cannot open the file

'filepath\movie2000.mdb'. It is already opened exclusively by another user,

or you need permission to view its data. 

/WEI/Sandbox/Database/connect2.asp, line 22

<!--End Error Message-->



The DB is not in use by anyone else and the folders all have the proper

permissions set.  If someone could provide me with a checklist of potential

problems that I can go through, I would be most appreciative.

Thank you!

Hey Aaron,



I'd like to know if you found a solution with this problem finally. If 

yes, please let me now what was it by putting a reply to this message.



Thanks in advance



Nick





> I'm having some difficulty in establishing a DB connection in the 

Movie2000

> example from Beginning ASP 3.0.  When I use the code provided in the 

book, I

> receive the following error message: 

> 

> <!--Begin Error Message-->

> Microsoft JET Database Engine error '80004005' 

> The Microsoft Jet database engine cannot open the file

> 'filepath\movie2000.mdb'. It is already opened exclusively by another 

user,

> or you need permission to view its data. 

> /WEI/Sandbox/Database/connect2.asp, line 22

> <!--End Error Message-->

> 

> The DB is not in use by anyone else and the folders all have the proper

> permissions set.  If someone could provide me with a checklist of 

potential

> problems that I can go through, I would be most appreciative.

> Thank you!

> 

Nick,



I finally found the solution.  My error was resolved by using an absolute 

filepath.  The source of this info is the Microsoft Knowledge Base, and 

the URL for the article is: 

http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP?LN=EN-

US&SD=gn&FR=0&qry=database%

20connection&rnk=16&src=DHCS_MSPSS_gn_SRCH&SPR=ASP.



Hopefully you'll find the solution to your problem somewhere in there.



-Aaron  



> Hey Aaron,

> 

> I'd like to know if you found a solution with this problem finally. If 

> yes, please let me now what was it by putting a reply to this message.

> 

> Thanks in advance

> 

> Nick

> 

>