Error # -2147467259 Access 2000 mdb VS 2003 mdb

[ajaxon98]

I have a VB 6 application that uses Access 2000 for data and reports.
Reciently I install this working application on an XP PC that has
Office 2003 installed. When I try to run the report I get the
following message under "Execution Error".
"Error # -2147467259 was generated by [my application name]
Microsoft Office Access can't open the database because it is missing,
or opened exclusively by anlther user."

My connection string is as follows...


* chMast.Open "provider=Microsoft.jet.oledb.4.0;" & _
* "data source=" & App.Path & "\Territories.mdb;"


The sub that calls the report is as follows...


*Private Sub genReport()
* Dim myMDB As Object
*
* Set myMDB = GetObject("c:\territory\territories.mdb",
"Access.Application")
* myMDB.Visible = True
*
* Screen.MousePointer = 11
*
* myMDB.docmd.runmacro "mData"
*
* Set myMDB = Nothing
*
*End Sub


My application has been installed on a number of XP systems and runs
fine. The only difference in this instance is that this PC has Office
2003 installed.
I tried to resume execution after the error thinking that, according to

some posts, there was a time out issue. I also tried convert the MDB
to the 2002-2003 version to address any compatability issues as
suggested to no avail.


Any help would be appreciated.


Thanks.


Anthony Jaxon
Los Angeles, CA USA

 

[Guest]

Hi Jason,

Verify that you do not have a locking database file (ie. territory.ldb)
remaining in the folder, when your application and Access itself are not
running in memory.

The user must have RWCD privileges on the folder in question (ie. App.Path
and/or c:\territory) and on the database itself.
Ref.: http://support.microsoft.com/kb/300699

About 3/4 the way down the page:
"The Microsoft Jet Database engine cannot open the file '<PathToFile>'. It
is already opened exclusively by another user, or you need permissions to
view it's data
Error
This error is typically caused when there are not enough file system
permissions for either the folder in which the database resides, or for the
database file itself. Users accessing your pages must have at least read,
write, create, and delete permissions to work with the .ldb file that is
created by the Microsoft Jet database engine.


Try re-registering the ADO library on the affected PC. Click on Start > Run.
Paste the following command into the run dialog path:

Regsvr32.exe "C:\Program Files\Common Files\system\ado\Msado15.dll"


It wouldn't hurt to ensure that the DAO library is properly registered as
well:

Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

If that doesn't work, make sure that you have the latest version of MDAC
(Microsoft Data Access Components) installed:
http://msdn.microsoft.com/dataaccess

Also recommended: Download the MDAC Component Checker utility and run it on
the affected PC:
http://support.microsoft.com/?id=307255


Good Luck!

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

I have a VB 6 application that uses Access 2000 for data and reports.
Reciently I install this working application on an XP PC that has
Office 2003 installed. When I try to run the report I get the
following message under "Execution Error".
"Error # -2147467259 was generated by [my application name]
Microsoft Office Access can't open the database because it is missing,
or opened exclusively by anlther user."

My connection string is as follows...


* chMast.Open "provider=Microsoft.jet.oledb.4.0;" & _
* "data source=" & App.Path & "\Territories.mdb;"


The sub that calls the report is as follows...


*Private Sub genReport()
* Dim myMDB As Object
*
* Set myMDB = GetObject("c:\territory\territories.mdb",
"Access.Application")
* myMDB.Visible = True
*
* Screen.MousePointer = 11
*
* myMDB.docmd.runmacro "mData"
*
* Set myMDB = Nothing
*
*End Sub


My application has been installed on a number of XP systems and runs
fine. The only difference in this instance is that this PC has Office
2003 installed.
I tried to resume execution after the error thinking that, according to

some posts, there was a time out issue. I also tried convert the MDB
to the 2002-2003 version to address any compatability issues as
suggested to no avail.


Any help would be appreciated.


Thanks.


Anthony Jaxon
Los Angeles, CA USA

 

[ajaxon98]

Thanks...you have given me a lot to look at....
I appologize for not stating that this application is running on a
single stand-alone PC. I will repost the results of your suggestions
on registering the various components you mentioned.

Thanks.

A.J.

Hi Jason,

Verify that you do not have a locking database file (ie. territory.ldb)
remaining in the folder, when your application and Access itself are not
running in memory.

The user must have RWCD privileges on the folder in question (ie. App.Path
and/or c:\territory) and on the database itself.
Ref.: http://support.microsoft.com/kb/300699

About 3/4 the way down the page:
"The Microsoft Jet Database engine cannot open the file '<PathToFile>'. It
is already opened exclusively by another user, or you need permissions to
view it's data
Error
This error is typically caused when there are not enough file system
permissions for either the folder in which the database resides, or for the
database file itself. Users accessing your pages must have at least read,
write, create, and delete permissions to work with the .ldb file that is
created by the Microsoft Jet database engine.


Try re-registering the ADO library on the affected PC. Click on Start > Run.
Paste the following command into the run dialog path:

Regsvr32.exe "C:\Program Files\Common Files\system\ado\Msado15.dll"


It wouldn't hurt to ensure that the DAO library is properly registered as
well:

Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

If that doesn't work, make sure that you have the latest version of MDAC
(Microsoft Data Access Components) installed:
http://msdn.microsoft.com/dataaccess

Also recommended: Download the MDAC Component Checker utility and run it on
the affected PC:
http://support.microsoft.com/?id=307255


Good Luck!

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

I have a VB 6 application that uses Access 2000 for data and reports.
Reciently I install this working application on an XP PC that has
Office 2003 installed. When I try to run the report I get the
following message under "Execution Error".
"Error # -2147467259 was generated by [my application name]
Microsoft Office Access can't open the database because it is missing,
or opened exclusively by anlther user."

My connection string is as follows...


* chMast.Open "provider=Microsoft.jet.oledb.4.0;" & _
* "data source=" & App.Path & "\Territories.mdb;"


The sub that calls the report is as follows...


*Private Sub genReport()
* Dim myMDB As Object
*
* Set myMDB = GetObject("c:\territory\territories.mdb",
"Access.Application")
* myMDB.Visible = True
*
* Screen.MousePointer = 11
*
* myMDB.docmd.runmacro "mData"
*
* Set myMDB = Nothing
*
*End Sub


My application has been installed on a number of XP systems and runs
fine. The only difference in this instance is that this PC has Office
2003 installed.
I tried to resume execution after the error thinking that, according to

some posts, there was a time out issue. I also tried convert the MDB
to the 2002-2003 version to address any compatability issues as
suggested to no avail.


Any help would be appreciated.


Thanks.


Anthony Jaxon
Los Angeles, CA USA

 

[ajaxon98]

Thanks...you have given me a lot to look at....
I appologize for not stating that this application is running on a
single stand-alone PC. I will repost the results of your suggestions
on registering the various components you mentioned.

Thanks.

A.J.

Hi Jason,

Verify that you do not have a locking database file (ie. territory.ldb)
remaining in the folder, when your application and Access itself are not
running in memory.

The user must have RWCD privileges on the folder in question (ie. App.Path
and/or c:\territory) and on the database itself.
Ref.: http://support.microsoft.com/kb/300699

About 3/4 the way down the page:
"The Microsoft Jet Database engine cannot open the file '<PathToFile>'. It
is already opened exclusively by another user, or you need permissions to
view it's data
Error
This error is typically caused when there are not enough file system
permissions for either the folder in which the database resides, or for the
database file itself. Users accessing your pages must have at least read,
write, create, and delete permissions to work with the .ldb file that is
created by the Microsoft Jet database engine.


Try re-registering the ADO library on the affected PC. Click on Start > Run.
Paste the following command into the run dialog path:

Regsvr32.exe "C:\Program Files\Common Files\system\ado\Msado15.dll"


It wouldn't hurt to ensure that the DAO library is properly registered as
well:

Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

If that doesn't work, make sure that you have the latest version of MDAC
(Microsoft Data Access Components) installed:
http://msdn.microsoft.com/dataaccess

Also recommended: Download the MDAC Component Checker utility and run it on
the affected PC:
http://support.microsoft.com/?id=307255


Good Luck!

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

I have a VB 6 application that uses Access 2000 for data and reports.
Reciently I install this working application on an XP PC that has
Office 2003 installed. When I try to run the report I get the
following message under "Execution Error".
"Error # -2147467259 was generated by [my application name]
Microsoft Office Access can't open the database because it is missing,
or opened exclusively by anlther user."

My connection string is as follows...


* chMast.Open "provider=Microsoft.jet.oledb.4.0;" & _
* "data source=" & App.Path & "\Territories.mdb;"


The sub that calls the report is as follows...


*Private Sub genReport()
* Dim myMDB As Object
*
* Set myMDB = GetObject("c:\territory\territories.mdb",
"Access.Application")
* myMDB.Visible = True
*
* Screen.MousePointer = 11
*
* myMDB.docmd.runmacro "mData"
*
* Set myMDB = Nothing
*
*End Sub


My application has been installed on a number of XP systems and runs
fine. The only difference in this instance is that this PC has Office
2003 installed.
I tried to resume execution after the error thinking that, according to

some posts, there was a time out issue. I also tried convert the MDB
to the 2002-2003 version to address any compatability issues as
suggested to no avail.


Any help would be appreciated.


Thanks.


Anthony Jaxon
Los Angeles, CA USA