UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Vb6ext.olb, Access 2016    
 
   
billwild
post Apr 22 2020, 11:12 AM
Post#1



Posts: 132
Joined: 4-June 02



For some reason I've list connectivity to VB6EXT.olb (VB error MISSING Microsoft Visual Basic 6.0 extensibility 5.3). Notice this when a query is trying to execute the Trim function. Any help would be appreciated.

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
theDBguy
post Apr 22 2020, 11:15 AM
Post#2


UA Moderator
Posts: 78,481
Joined: 19-June 07
From: SunnySandyEggo


Hi. Are you using Windows 10? There was an update recently that may have removed or unregistered it. You may have to reregister it.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
billwild
post Apr 22 2020, 11:19 AM
Post#3



Posts: 132
Joined: 4-June 02



Yes I have 10 and it was recently updated. How do I re-register it if I can't find the file?

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
FrankRuperto
post Apr 22 2020, 11:27 AM
Post#4



Posts: 1,102
Joined: 21-September 14
From: Tampa, Florida USA


See: https://www.UtterAccess.com/forum/index.php...t&p=2749943

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page
 
billwild
post Apr 22 2020, 04:38 PM
Post#5



Posts: 132
Joined: 4-June 02



so is there not an option for this missing OLB? I've used this same program for over 15 years and now all of a sudden it craps on me! NOT HAPPY

--------------------
always learning....<img src="/forums/images/graemlins/laugh.gif" alt="" />
Go to the top of the page
 
FrankRuperto
post Apr 22 2020, 05:42 PM
Post#6



Posts: 1,102
Joined: 21-September 14
From: Tampa, Florida USA


I don't blame you for being unhappy, but I dont think your olb is missing, its just blocked and you have to unblock it with group policy settings and re-register it with regsvr32
Visit this link for instructions: https://support.microsoft.com/en-us/help/45...ecurity-updates

To Re-register the VBE6EXT.OLB file, follow the steps below.

Launch the command prompt as admin and type:

regsvr32 -u "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB"

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB"

Make sure your locations are correct and the file is in that location on your machine.

This post has been edited by FrankRuperto: Apr 22 2020, 05:49 PM

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page
 
isladogs
post Apr 23 2020, 01:03 AM
Post#7


UtterAccess VIP
Posts: 2,400
Joined: 4-June 18
From: Somerset, UK


That's interesting...
My copy of VB6EXT.OLB is in ‪C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6.
I can see and use it from Access but the VBA subfolder is hidden in File Explorer even when Show Hidden Items is ticked.
Presumably a permissions issue.

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
FrankRuperto
post Apr 23 2020, 06:20 AM
Post#8



Posts: 1,102
Joined: 21-September 14
From: Tampa, Florida USA


Its visible in my Win7 box. Maybe you're not logged in as Admin, or Win10 now hides it?
This post has been edited by FrankRuperto: Apr 23 2020, 06:26 AM
Attached File(s)
Attached File  VisibleFile.PNG ( 233.53K )Number of downloads: 4
 

--------------------
Currently supporting pawnbrokers that use my store management system developed with Access 2010 on Windows7. Experienced with Informix, Oracle & PostgreSQL db's.
Go to the top of the page
 
isladogs
post Apr 23 2020, 08:19 AM
Post#9


UtterAccess VIP
Posts: 2,400
Joined: 4-June 18
From: Somerset, UK


I'm logged on as an administrator on all my PCs.

The PC I originally tried is a tablet running Win 10 Home version where the folder isn't visible in Explorer
However, its visible on another PC also running Win 10 Pro version.
I'll test on a laptop later - also with the Home version

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    11th July 2020 - 01:16 PM