-
Nov 15th, 2018, 03:43 AM
#1
Thread Starter
New Member
[RESOLVED] ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
I'm getting an "ActiveX Component Can't create object" error (Run-Time 429) on the Set objPassport = CreateObject("PASSPORT.System") line.
Sub Main()
Dim Sessions As Object
Dim System As Object
Set objPassport = CreateObject("PASSPORT.System")
objPassport.Sessions.Open ("C:\Program Files\PASSPORT\PASSPORT.ZWS")
End Sub
OS Version : Widows 10
Any support is greatly appreciated!
-
Nov 16th, 2018, 05:31 AM
#2
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
is the version installed on your windows 10 a 32 bit application?
is it correctly registered with elevated privileges?
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Nov 17th, 2018, 10:30 AM
#3
Fanatic Member
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
Chances are this is a 64bit component like westconn said. You can verify this by creating a vbs script with one line like:
Code:
Set objPassport = CreateObject("PASSPORT.System")
Save it as c:\t.vbs
and running it using this command in your already opened cmd.exe window (don't just paste into Run):
C:\Windows\SysWOW64\cscript.exe c:\t.vbs
This will force a 64 bit interpreter. If you don't see any errors, then you know you need to use a 64 bit office install.
-
Nov 19th, 2018, 02:03 AM
#4
Thread Starter
New Member
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
MS office version : 64bit
Passport application version : 32bit
OS version : windows 10 - 64bit
Kindly let me know what needs to be done ?
-
Nov 19th, 2018, 01:54 PM
#5
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
This is why the industry standard is 32bit office.
64bit office isn't compatible with 32bit components (which is the vast majority of them).
https://support.office.com/en-us/art...rs=en-US&ad=US
-
Nov 19th, 2018, 03:13 PM
#6
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
This is why the industry standard is 32bit office.
i guess this is due to change, as more 64 bit solutions are provided
i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next
dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part
come back and mark your original post as resolved if your problem is fixed
pete
-
Nov 19th, 2018, 04:09 PM
#7
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
Originally Posted by westconn1
i guess this is due to change, as more 64 bit solutions are provided
There were some major incompatibilities between the 64bit and 32bit access runtimes, where only one runtime could be installed on a machine at a time - and you couldn't use a 32bit accdb/accde with the 64bit runtime.
I think this was eventually fixed, but talk about a mess.
Without even considering all the 32bit API declarations in custom VBAs, it was easier just to say everyone use 32bit.
So yeah - when will we get to a point where the pluses outweigh the minus?
There needs to incentives stronger than Documents larger than 4GB
-
Nov 20th, 2018, 04:02 AM
#8
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
1.
Originally Posted by David@Tinku
Set objPassport = CreateObject("PASSPORT.System")
Where you declared? I don't see in your code:
Code:
Dim objPassport As Object ???
2.
Originally Posted by David@Tinku
objPassport.Sessions.Open ("C:\Program Files\PASSPORT\PASSPORT.ZWS")
If PASSPORT is a 32bit component, why the path you use is the 64bit one ???
For 32bit should be: C:\Program Files (x86)
-
Nov 20th, 2018, 05:33 AM
#9
Thread Starter
New Member
Re: ActiveX Component Can't create object" error (Run-Time 429) - Passport.System
Thank you guys. Issue is resolved. I reinstalled 32 bit version MS office and it worked fine. Appreciate your help and time.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|