samuelpajilewski
asked on
MS Access 2000 Error : CurrentDb from _Application Failed
Hi !
I have developped a MS Access Application.
In my computer it runs fine but when I put the MS Access Application in another PC I get a strange error :
Error of Execution '-2147024770 (8007007e)'
Method 'CurrentDb' of Object '_Application' failed
Though, the PC has the same OS (Win 2000) and the same Access (2000).
When the application meet the CurrentDb error it causes the error.
So may be it is because there is a conflict between Office XP and Access 2000, may be I need to check the System database or something else.
Maybe the Vba module is corrupted.
It is very important, could you help me, please ?
I have developped a MS Access Application.
In my computer it runs fine but when I put the MS Access Application in another PC I get a strange error :
Error of Execution '-2147024770 (8007007e)'
Method 'CurrentDb' of Object '_Application' failed
Though, the PC has the same OS (Win 2000) and the same Access (2000).
When the application meet the CurrentDb error it causes the error.
So may be it is because there is a conflict between Office XP and Access 2000, may be I need to check the System database or something else.
Maybe the Vba module is corrupted.
It is very important, could you help me, please ?
Assuming that you have written VBA scripting to control the database then I would suggest changing from using the CurrentDB command that is a quick reference to using a full definition of the databases location. It might just be that the currentDB command is looking where the database is not.
my guess is that you have a reference out of whack. for instance, you might be referencing the Office 9 (2000) library instead of the Office 10 library (xp)
check your references and be sure that they are referring to the right versions...
dovholuk
check your references and be sure that they are referring to the right versions...
dovholuk
ASKER
Hi !
There is the script :
Dim dbs As Database
'Ouverture de la base M. Griffon and M. dovholuk
I will try to put another command before using Currentdb :
me.application.opencurrent db("Pathto myDatabase ")
Maybe it will solve my pb.
Also I will try :
me.application.opennewdb(" Pathtomyda tabase")
Thanks
Set dbs = CurrentDb
So the following code is not really interesting.
I will try the solution of
There is the script :
Dim dbs As Database
'Ouverture de la base M. Griffon and M. dovholuk
I will try to put another command before using Currentdb :
me.application.opencurrent
Maybe it will solve my pb.
Also I will try :
me.application.opennewdb("
Thanks
Set dbs = CurrentDb
So the following code is not really interesting.
I will try the solution of
You've got a VBA reference problem. Check out the list of libraries when the code is halted on the second PC.
ASKER
Hi !
I tried to check the references of MSAccess.
(Modules->Tools->Reference s)
So 5 libraries are loaded :
Vba for Application
Active X libraries
MS Access Libraries (MSAC9.OLB something like that)
2 others libraries.
I have the same libraries selectioned in my PC where the application works. So it is not a pb of references, maybe the DAO or Access libraries are corrupted, but I don't know
Any suggestion would be greatly appreciated
I tried to check the references of MSAccess.
(Modules->Tools->Reference
So 5 libraries are loaded :
Vba for Application
Active X libraries
MS Access Libraries (MSAC9.OLB something like that)
2 others libraries.
I have the same libraries selectioned in my PC where the application works. So it is not a pb of references, maybe the DAO or Access libraries are corrupted, but I don't know
Any suggestion would be greatly appreciated
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
- PAQ'd and pts refunded
Please leave any comments here within the
next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !
Nic;o)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you post the script that is causing the error
Thanks
Jell