f



kb969898 Windows Update Broke MSComm control, maybe other VB controls, in Access 2003

Greetings,

Here's a strange one for you. I have an Access 2003 app that uses the 
MSComm32 ActiveX control (From VB6) to talk to a serial printer. It has 
worked fine for years, but as of the Windows Update earlier this week (I 
narrowed it down to kb969898, which is a kill bits update to block 
malicious behavior by ActiveX controls in IE, but seems to also include 
VB6 SP6 as well).

Links:
The kb: http://www.microsoft.com/technet/security/advisory/969898.mspx
The VB6 SP6: http://support.microsoft.com/?kbid=957924

During execution of the form with the control, I get Error 438 - 'Object 
doesn't support this property or method'. (happens on the first line of 
code that refers to the control, specifically, the .CommPort property, 
but I think any property or method would trigger the error, see next 
paragraph)

So, I went into design view and then get 'There is no Object in this 
control'. The control no longer shows as a telephone icon, but blank.

I tried these without success:
- Re inserting the control
- Re registering the control
- Adding a reference to the control and using as an object variable 
instead of as a control
- Creating a brand new db and form and adding the control

Then on a whim, I tried it in Access 97, and the control works just like 
before.

Removing the update returns functionality to normal.

According to the link on the VB SP6, there is a known issue, that is 
described as being similar (Different wording of the error messages, but 
same net effect) with a solution of clearing the DLL cache (delete .exd 
files), but there are no such files on the system (neither mine or my 
customer's).

SO, does anyone have any ideas of what else to try? Is there another 
type of control cache file to look for? Is there an alternate control 
for sending data to a Comm port (ala DOS, sending ESC characters and raw 
text)?

The list of controls 'fixed' in VB SP6 is quite long, so this problem 
might happen with other VB controls used in Access 2003.

Thanks in advance for any help, pointers, etc. that you might have.

--
Bri
0
not32 (1022)
6/12/2009 5:59:57 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

3 Replies
474 Views

Similar Articles

[PageSpeed] 46

Bri <not@here.com> wrote:

>Here's a strange one for you. I have an Access 2003 app that uses the 
>MSComm32 ActiveX control (From VB6) to talk to a serial printer. It has 
>worked fine for years, but as of the Windows Update earlier this week (I 
>narrowed it down to kb969898, which is a kill bits update to block 
>malicious behavior by ActiveX controls in IE, but seems to also include 
>VB6 SP6 as well).
>
>Links:
>The kb: http://www.microsoft.com/technet/security/advisory/969898.mspx
>The VB6 SP6: http://support.microsoft.com/?kbid=957924

You need to either distribute a new copy of your app along with the updated OCX or
remove the OCX completely and use an atlernative method of accessing the serial port.

See the Serial Port Communications page at my web site.
http://www.granite.ab.ca/access/serialport.htm

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
0
ttoews (2789)
6/12/2009 8:03:46 PM
Tony Toews [MVP] wrote:
> Bri <not@here.com> wrote:
> 
>> Here's a strange one for you. I have an Access 2003 app that uses the 
>> MSComm32 ActiveX control (From VB6) to talk to a serial printer. It has 
>> worked fine for years, but as of the Windows Update earlier this week (I 
>> narrowed it down to kb969898, which is a kill bits update to block 
>> malicious behavior by ActiveX controls in IE, but seems to also include 
>> VB6 SP6 as well).
>>
>> Links:
>> The kb: http://www.microsoft.com/technet/security/advisory/969898.mspx
>> The VB6 SP6: http://support.microsoft.com/?kbid=957924
> 
> You need to either distribute a new copy of your app along with the updated OCX or
> remove the OCX completely and use an atlernative method of accessing the serial port.
> 
> See the Serial Port Communications page at my web site.
> http://www.granite.ab.ca/access/serialport.htm
> 
> Tony

I can't distribute the App with the new control because I can't add it 
to the form. I select it to insert on the form and get 'MyAppName 
doesn't support this ActiveX Control."

I followed the link to your page and I like the code in the first link 
(uses API to talk to the COMM Port). I've modified my app to use that 
instead of the control and will test it at the clients on Monday. This 
looks like it will solve the problem nicely. I really never liked the 
idea of using a control for this in the first place, but didn't know how 
else to do it (I wrote this originally several years ago). I first tried 
the old DOS VB methods of Printing to the COMM port, without success.

Thanks for this info. :)

--
Bri
0
not32 (1022)
6/12/2009 11:24:38 PM
Bri <not@here.com> wrote:

>I can't distribute the App with the new control because I can't add it 
>to the form. I select it to insert on the form and get 'MyAppName 
>doesn't support this ActiveX Control."

You'd have to install the new ActiveX control on your system.

>I followed the link to your page and I like the code in the first link 
>(uses API to talk to the COMM Port). I've modified my app to use that 
>instead of the control and will test it at the clients on Monday. This 
>looks like it will solve the problem nicely. I really never liked the 
>idea of using a control for this in the first place, but didn't know how 
>else to do it (I wrote this originally several years ago). I first tried 
>the old DOS VB methods of Printing to the COMM port, without success.
>
>Thanks for this info. :)

You're welcome.  And that's a better long term solution of course.

Tony
-- 
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/
0
ttoews (2789)
6/13/2009 8:22:01 PM
Reply:

Similar Artilces:

Internet Access Control in Windows Server 2003
Hi, We have a number of groups, in two different cities, who need to access specific external websites to do their jobs. Our Big Boss wants to move away from our inefficient peer-to-peer network and put a Windows Server 2003 environment in place in stages, starting with the ability to limit employees to only those sites that their specific function requires them to access. Now as I see it, we need two servers, one in each city, to accomplish this. In each city we need a Domain Controller, housing Active Directory, and a member server to run ISA Server 2004 for the internet access con...

Internet Access Control in Windows Server 2003
Hi, We have a number of groups, in two different cities, who need to access specific external websites to do their jobs. Our Big Boss wants to move away from our inefficient peer-to-peer network and put a Windows Server 2003 environment in place in stages, starting with the ability to limit employees to only those sites that their specific function requires them to access. Now as I see it, we need two servers, one in each city, to accomplish this. In each city we need a Domain Controller, housing Active Directory, and a member server to run ISA Server 2004 for the internet access con...

problem accessing access 97 database through odbc on windows 2003 sp1
Hello, We have a legacy application which relies on an Access 97 database (upgrading is nog an option atm). As we are setting up a new server (Windows 2003), we started experiencing problems running that application after installing all required updates (Windows, Office, ..) It did work before updating, with a basic OS + application installation. Somewhere an update dit break things, but we do not know which one. Now for the problem. When starting the application, following error is returned: --------------------------- ODBC Microsoft Access Driver Login Failed ---------------------------...

Making a form control the criteria for the sql statement of another control (Access 2003)
I have two comboboxes on a form. Combobox1 uses field1 in another table as its source of data. What I want to do is to enable combobox2 to use field2 in that table, but only to show the rows of data that contain the item selected in combobox1. At the moment I can easily write a SQL statement with a WHERE clause, but I only know how to specifiy static criteria. What I want is a variable criteria, where the criteria is the data contained in combobox 1. Is this possible? thanks for any help :) Ste "SteMc" <google@jasmonio.supanet.com> wrote >I have two comboboxes on a fo...

[rfc-dist] RFC 5417 on Control And Provisioning of Wireless Access Points (CAPWAP) Access Controller DHCP Option
A new Request for Comments is now available in online RFC libraries. RFC 5417 Title: Control And Provisioning of Wireless Access Points (CAPWAP) Access Controller DHCP Option Author: P. Calhoun Status: Standards Track Date: March 2009 Mailbox: pcalhoun@cisco.com Pages: 6 Characters: 11551 Updates/Obsoletes/SeeAlso: None I-D Tag: draft-ietf-capwap-dhc-ac-option-02.txt URL: http://www.rfc-editor.org/rfc/rfc5417.txt The Control And Provisioning of Wireless Access Points Protocol allows a Wireless Termination Point to use DHCP to discover the Access Controllers to which it is to connect. This document describes the DHCP options to be used by the CAPWAP Protocol. [STANDARDS TRACK] This document is a product of the Control And Provisioning of Wireless Access Points Working Group of the IETF. This is now a Proposed Standard Protocol. STANDARDS TRACK: This document specifies an Internet standards track protocol for the Internet community,and requests discussion and suggestions for improvements. Please refer to the current edition of the Internet Official Protocol Standards (STD 1) for the standardization state and status of this protocol. Distribution of this memo is unlimited. This announcement is sent to the IETF-Announce and rfc-dist lists. To subscribe ...

Create MS/ACCESS database app for non-ms/access users
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Per Sue Bricker: >Is it possible to create an MS/ACCESS database application and package >it for users who do not have MS/ACCESS loaded in their PCs? > >I was told that this is possible, but...

Can I update a MS Access 2002 database with Visual Basic .net 2003 Standard Editon?
I am considering purchasing Visual Basic .net 2003 Standard Editon to do some development work with Web Forms and I need to know whether this edit will allow me to update an Access database (mdb) file. I already have a database which is updated through an Access front-end, I want to update the database through web forms, is this possible? what are the benefits of going for the Professional Verion of Visual Studio instead? Cheers, In VB.Net you'd use the ADO.Net objects to update the database. Visual Studio.Net is just another Rapid Application Development (RAD) tool. It has the added ...

how to access database control of many oracle10g database instances on same server
I am on Redhat Linux 9 and using Oracle 10G (10.0.1.3?). I know how to create a Oracle database instance and use EM database control to administer the database. To access database control from a browser, Oracle asks to enter a URL: http://server_name:5500/em The URL does not specify the ORACLE_SID. I however want to create several database instances on the same box. Will Oracle automatically set up a different port (e.g., 5501) for second instance. All the documentation I have found on Oracle's web site refers to a single database instance on a server. Appreciate any pointers. Thanks a lot, Prem You need to read about Grid Control. Actually when you create your database using DBCA, it should ask you whether you want to use Grid Control or DB Console. Jining Han Jining Han wrote: > You need to read about Grid Control. Actually when you create your > database using DBCA, it should ask you whether you want to use Grid > Control or DB Console. > > Jining Han I hae read about Grid Control, but I think there is still a way to access many instnaces on the same server using database control. Prem Of course you can, a DB Console for each database, and you can choose that as your preferred approach, too. But I really think it's a waste of resources and a big inconvenience. You are probably better off with the "tradictional" desktop console. Just my 2 cents. Jining Han <premmehrotra@hotmail.com> wrote in message news:...

request for explanation on access an database in ms access
This is the code that I found on the internet for accessing an ms access database: import java.sql.*; class Test { public static void main(String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // set this to a MS Access DB you have on your machine String filename = "d:/java/mdbTEST.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end // now we can get the connection from the DriverManager Connection con = DriverManager.getConnection( database ,"",""); } catch (Exception e) { System.out.println("Error: " + e); } } } What I don't understand is the declaration of database. What I did was putting the database in the same dir as the sourcecode and use "jdbc:odbc:CafeJolt.mdb". But this doesn't work. And the above code does, why is that??? Actually it's not Java question. It's ODBC question. You have to have ODBC connection. Depending of Windows it's usually something like this (for my Windows 2000): Start->Sttings->Control Panel->Administartive Tools->Data Sources(ODBC)-> User DSN -> [Add]-> Driver to Microsoft Access(*.mdb) === And here, finally you can choose file name. ...

Access MS-ACCESS database on server from client????
I m currently developing a java based application and want to know how can i make client access database located on the server? "HeMan_Speaks" <Lunar20092010@gmail.com> wrote in message news:d71ce567-0434-48b8-b1d2-bb191706ab45@w8g2000prd.googlegroups.com... >I m currently developing a java based application and want to know how > can i make client access database located on the server? I think you're going to have to expand a little bit more in your question here, as is not 100% quite clear what you're trying to do. You might want to make a little bit of a distinction between MS access, the development system that allows you to write code, build forms, and build reports, and that of the database engine that you choose to use with MS access. When you build an application MS access, you then choose your database engine, that might be oracle, SQL server, or perhaps more often leave the default jet database. So when you say make a client access application, are you talking about a piece of software that you plan to install and each computer? The fact that your introducing the issue of java further complicates your question. Perhaps your question is simply you have some java code running on a server, and with to open a mdb file (an access database file). In this situation you're not really using MS access at all here (you using what is called the jet database engine to read that mdb file). For all the trouble in this type of sce...

MATLAB command to access MS Access database
Hi! Is there a MATLAB command which gives access to a .mdb MS Access database or do I need a special driver? Thanks, Andree Hi Andree Ellert, you can use activeXcontrol to interact with MS-Access database. access = actxserver('Access.Application'); returns the handle for Access. set(access, 'Visible', 1); will show the opened Access window. use get(access) and set(access) commands to find the methods available to call. -Vadivelu M =========== http://www.mathworks.com/access/helpdesk/help/toolbox/database/datatool.shtml "Andree Ellert" <ellert@gmx.net/////\\\\\> wrote in message news:eed9874.-1@webx.raydaftYaTP... > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree Andree Ellert wrote: > > > Hi! > > Is there a MATLAB command which gives access to a .mdb MS Access > database or do I need a special driver? > > Thanks, > > Andree <http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=4045&objectType=file> -Hardik ...

OT: MS Access runtime wants to control all MS Office charts
Office 97, Access 97, Sagekeys scripts. In addtion of Access 97, my runtime package is installed too. This is an old application that has been running since 1998. The customer is happy with it. I have a glitch in.... Powerpoint 97. When an user double-clicks a chart, it starts my Ms Access Runtime Installer! It will do the same if he right-clicks and uses 'Edit'. If he selects 'Open', it will do it in a separate windows and it is Ok. Thius probably comes because MS Chart is shared among office apps. I would really like to have this problem even if there is a turnarou...

ms-access database cannot be updated
I have a ms-access application. The front end is ms-access and the backend is SQL Server. Originallly it worked well on windows 2000 machine. After the machine is re-imaged to windows xp machine. The application cannot be updated. All the textbox or dropdownlist become readonly. There are no particular error message. The screen is just freeze when you are trying to do update. Can someone help with this issue? Thanks! ...

Fire-up MS Access Database from VB and Leave it Running When VB App is Closed?
Hiya, Anybody know how to do this please? I am opening Access from VB using the code below. However, I don't want Access to close when objAccess goes out of scope. I would like Access to remain open - like MS Excel does if you write similar code. I am trying to avoid using the Shell function because I don't want to have to search for MSAccess.exe first. If you step through the code and click on the Access session before continuing through the VB code, it seems to know that you have interacted with it and leaves Access open. I have tried throwing in an AppActivate "MsAccess"...

Best way to access a remote MS ACCESS database
What is the best way, via the internet, to access a remote Microsoft Access database? I was thinking of using VPN, but I thought that I would check here to see if there is a better way. Any suggestions? Thanks Do you mean remotely controlling an Access database, or linking tables over the internet? The first is doable, the second is a recipe for disaster. Remote Control: If your remote OS is Windows XP, you can use Remote Desktop (although only 1 person can access the PC at a time; this will change in the upcoming Service Pack for XP, but that may not help you now). Otherwise, GoToMyPC offers similar services, as does Terminal Server (a component of a Windows Server machine), PCAnywhere, et al. Linking to remote tables: You will almost certainly encounter severe problems with corruption, and your performance will almost certainly be so poor as to be unworkable. I attempted this once, with a web server in Canada and my machine in Augusta, GA. Even tiny data requests on a very well optimized data structure took waaaay too long to process ... it's simply not workable, IMO. Other alternatives would be covert the app to a web-based and place your data on a web server. Access/Jet isn't really designed for those workloads, but running a small site with minimal transactions and users can be done. Otherwsie, consider switching to a more robust data platform like MySQL, SQL Server, etc. -- Scott McDaniel CS Computer Software Visual Bas...

Convert Access 2003 database file to Access 2010
How do you convert a Access 2002-2003 database file to a Access 2010 file format? According to Microsoft (http://office.microsoft.com/en-us/access-help/ convert-a-database-to-the-accdb-file-format-HA010341552.aspx? queryid=34ea405f95aa4cb8b8ffb2764afb4993&respos=0&CTT=1) it is possible. When I tried this on the file tab it only displays the print options only. How can I get the save, save & publish, and other commands to display? My 2002-2003 Access database file has 3 tables, 19 queries, 5 forms, and 16 reports. After I open the file up it gives the "Security Warning: Soame active content has been disabled. Click for more details." then there is a button "Enable Content". Before and after I click the "Enable Button" the file tab only has print options available. Thank you for your help, jfcby jfcby <jamesfc30@gmail.com> wrote in news:f4dc9993-afa3-4fed-8180-22786eaa7f83@l14g2000yql.googlegroups.co m: > How do you convert a Access 2002-2003 database file to a Access > 2010 file format? > > According to Microsoft > (http://office.microsoft.com/en-us/access-help/ > convert-a-database-to-the-accdb-file-format-HA010341552.aspx? > queryid=34ea405f95aa4cb8b8ffb2764afb4993&respos=0&CTT=1) it is > possible. When I tried this on the file tab it only displays the > print options only. > > How can I get the save, save & publish, and other commands to > display? ...

How to access only boolean control value that is part of a cluster of controls
I have created a set of boolean controls in a cluster. Is there a way to access only one of the boolean control (i.e. "stop" button) so that I can change its states in the program, indepent of the rest of the boolean controls in the same cluster? &nbsp; Thanks! &nbsp; -NewUser2007 NewUser2007 wrote:-once I unbundle the boolean clusters and selected the stop boolean, how can I "wire a new value" to it (since it was created as a boolean control).&nbsp; I never said anything about "unbundle"! There is a 180� difference between "unbundle" and "bundle". :) You only need to unbundle if you want to know the current value, this is not needed if you want&nbsp;to write a new value regardless of what the current value is. &nbsp;<img src="http://forums.ni.com/attachments/ni/170/287328/1/clusterModify.png"> Message Edited by altenbach on 11-29-2007 08:20 AM clusterModify.png: http://forums.ni.com/attachments/ni/170/287328/1/clusterModify.png ...

Accessing MS ACCESS database using Data Environment
HI, I have developped a program in Visual Basic 6.0 using MS Access database. I have created all my reports through Data Environment where I have entered the location of my database file (for e.g c:\project\app\test.mdb) in the Connection properties. I have installed my application on another PC using Package & Deployment wizard. When viewing the reports on the other PC, I have to enter everytime the new location of the database. How can I solve this problem, please? nadia wrote: > HI, > I have developped a program in Visual Basic 6.0 using MS Access database. >...

Accessing a MS Access database across two servers
Hi The technical support guys at my company have set up my system so that the server containing the MS Access database is on one server, while the pages that should access the database are on another server. When the pages and database are on the same server, I usually just connect through ODBC. The problem is that I don't know how to set up an ODBC connection to link from one server to a database in another. Anyone know what I am getting at and know of a possible solution, or a link to a site which may help. thanks in advance Brendan "Singularity" <Brendan.Collins@Sin...

Convert Access 2010 to Access 2003 under windows 7
This is further information on my posting about converting Access 2010 to Access 2003 I have just removed and re-installed Office 2010 32 bit on my Windows 7 machine. If I create a completely blank database (Database9.AccDb) - no tables, no forms, no VBA and try to Save & Publish in Access 2003 format, I get an error message message "Could not use 'C:\Phil Data\Access\Database9.AccDb'; file already in use" . If I add any tables, the error is the same I have Access 2010 running under Windows XP on another machine, and the conversion of a genuine BE Db (Tables only) went without a hitch. Anyone else found the same problem? Phil Phil was thinking very hard : > This is further information on my posting about converting Access 2010 to > Access 2003 I have just removed and re-installed Office 2010 32 bit on my > Windows 7 machine. If I create a completely blank database (Database9.AccDb) > - no tables, no forms, no VBA and try to Save & Publish in Access 2003 > format, I get an error message message "Could not use 'C:\Phil > Data\Access\Database9.AccDb'; file already in use" . If I add any tables, the > error is the same > > I have Access 2010 running under Windows XP on another machine, and the > conversion of a genuine BE Db (Tables only) went without a hitch. Anyone else > found the same problem? Phil Sounds like a Windows 7 Permissions issue to me. Are you an Admin on this machine? Does the Folde...

Tab Events of Access Application ? (NOT Access Tab Control)
I'm trying to use the event when a person moves to a different form by clicking on the built in Access application tabs. Is there something I can reference or does it require some kind of subclassing/hook api calls? Thanks On Jul 21, 9:47=A0pm, "christianlo...@yahoo.com" <christianlo...@yahoo.com> wrote: > I'm trying to use the event when a person moves to a different form by > clicking on the built in Access application tabs. > > Is there something I can reference or does it require some kind of > subclassing/hook api calls? > > Thanks Hi Christian, You can use the OnDeactivate event. Imb. > You can use the OnDeactivate event. Hello Imb, Aha. Now I am forced to make an event for each form. Trying to automate what tab the ribbon moves to based on the access application tab. Okay, thanks. Access could use a rewrite of it's event system imho. There are no top level application events to tap into, no 'after delete' event, record saves w/ a 'dirty=true', it's all quite ridiculous. I was hoping the new table events would be the solution but they come up w/ this 'data macro' crap where there doesn't seem to be any way to call your own code on the event. Sometimes I wonder if the ms developers ever use Access. However, I love the report and form design improvements. <christianlott1@yahoo.com> wrote in message news:ba72c614-57c0-4045-9af0-3cd9734e923b@r18g2000vbs.googlegro...

Import MS Office Excel Comma Separated Values Files into a MS Access 2003 database
Hi, I have been tasked with Importing MS Office Excel Comma Separated Values Files into a MS Access 2003 database. These files were exported from a DB2 database.I have also been given the DDL code. I have Googled a solution to this task and have tried creating these tables using the DDL code in a query within a blank MS Access database. Is there a more expedient way to achieve this? I noticed, for example, that a field in DB2 has a data type of "decimal" while the same field would have the data type of "number". Thanks, Zuf What follows is the DDL: -------...

user control in Access database file ?
Hello!!! Can i add a user control in Access database file (mdb)? I want to make o form in an mdb file and i want to add my button. Hope You can help me. Thanks ...

Order of accessing controls in Data Windows
I have added a combobox control to a data window but when I run the app the new control gets accessed last. I know I have changed the order in which the data is accessed but I can't remember how. Can anyone enlighten me on this a little? Also I use 'Exploring CA-Visual Objects 2.5' as a bible. Is there any newer CA books to help less than brilliant programmers like me? Thank you On Fri, 21 Jul 2006 16:39:21 GMT, "Grant" <grantd@dunsmoreinfo.com> wrote: Hello Grant, >I have added a combobox control to a data window but when I run the ap...

Web resources about - kb969898 Windows Update Broke MSComm control, maybe other VB controls, in Access 2003 - comp.databases.ms-access

10 Microsoft Security Bulletins for June 2009
Donna's SecurityFlash points you to interesting stories and news about PC and internet security.

Resources last updated: 3/20/2016 3:13:27 PM