ActiveX Component Can't Created Object

[nileshhthakur2004]

hi all,

i have post one Question before this for the error when i install my application on client's pc it gives me error "ActiveX Component Can't Created Object " some of you give me answer of installing of MDAC file but still it gives me error message each time when i start my application
if please help me regarding this

i have created one application in vb 6.0 and use the database access 97 which is send by my client i have the access 2000 on my pc but i am not convert that db to 97 i use it as it is after compliting my application i create one exe and installer ( Package ) which contain the DB also when i am trying to insatlled it on my client's pc it show me error "ActiveX Component Can't Created Object " can any budy tell me why ???

i have install the MDAC version of his mc but it still show me same error Please help me

thanx in advance,

Regards,

Nilesh Thakur.

[randem]

Please read Installation Problems and Database Problems in my signature for some helpful insight.

[Harsh Gupta]

hi all,

i have post one Question before this for the error when i install my application on client's pc it gives me error "ActiveX Component Can't Created Object " some of you give me answer of installing of MDAC file but still it gives me error message each time when i start my application
if please help me regarding this

i have created one application in vb 6.0 and use the database access 97 which is send by my client i have the access 2000 on my pc but i am not convert that db to 97 i use it as it is after compliting my application i create one exe and installer ( Package ) which contain the DB also when i am trying to insatlled it on my client's pc it show me error "ActiveX Component Can't Created Object " can any budy tell me why ???

i have install the MDAC version of his mc but it still show me same error Please help me

thanx in advance,

Regards,

Nilesh Thakur.

could you tell us the exact configuration which you and your client are using?

if by any chance you developed you project on higher version of MDAC (than what your client are using), then you can take a look at MDAC - component checker. though it requires Validation of *something* (sorry i dont know exactly, but it may test the validation of the OS)

[nileshhthakur2004]

I am using the windows 2000 and having access 2000 on my pc but i use the db which is created in 97 i am not converted it and my client having windows 98 and access 97 on his side,he is having windows 95 and access 97 on other machine where he want to run this application.

regarding this please help me

Regards,

Nilesh Thakur.

[randem]

post your connection code.

[nileshhthakur2004]

hi randem as in this thread you told me to post the code

i am post my code

my problem is that when i am Compacting the data it show me the error

error 429 : ActiveX Component Can't Created Object

is this because of bugs in Code or because of the version problem ( reffrence problem ) ??

cause it run on my pc well i have access 2000 and Operating System is 2000 but not on my Client's Maching he is having access 97 and windows 98

here is my code

Public Function CompactDB()

MsgBox "first line"
On Error GoTo CompactDB_Err

' Compact the database to a temp file.
MsgBox "Compact the database to a temp file."
DBEngine.CompactDatabase App.Path & "\UPSThermalLabels.mdb", App.Path & "\Temp.mdb"
MsgBox "Compacting DONE successfully."

' Delete the previous backup file if it exists.
MsgBox " Delete the previous backup file if it exists."
If Dir(App.Path & "\UPSThermalLabels.bak") <> "" Then
Kill App.Path & "\UPSThermalLabels.bak"
End If
MsgBox " Deleted successfully ."

'Rename the current database as backup and rename the temp file to ' the original file name.

MsgBox " rename as .bak"
Name App.Path & "\UPSThermalLabels.mdb" As App.Path & "\UPSThermalLabels.bak"
MsgBox " rename temp.mdb as the original ."
Name App.Path & "\Temp.mdb" As App.Path & "\UPSThermalLabels.mdb"
MsgBox " deleted .bak"
Kill App.Path & "\UPSThermalLabels.bak"
MsgBox " Deleted successfully ."

'MsgBox "Compacting is complete"

Exit_CompactDB:
Exit Function

CompactDB_Err:
MsgBox "Error Number: " & Err.Number & " Error Description : " & Err.Description
Resume Exit_CompactDB

End Function

thanx in advance,

Regards,
Nilesh Thakur.

[randem]

That code looks strangely familiar. You should use VBCODE tags in your posting of code. There is no connection code in your sample. Check your code for code that opens the connection to the database. Since you are using DAO you need to install the Jet 3.51 Engines.