The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to import mesurement data from an instrument into an ACCSS 2007 database via serial USB port
Posted on 2010-08-21
I can transfer mesument data from a mesurement instrument to an ACCSS 2003 database via a serial port using the AXCOM object. The problem is that in the ACCESS 2007 version this object is not recognized and an error occurs. Maybe I'm not using the correct object or method to access data adequate to this version? Is there another object or method that implements this communication? I suspect that the ACCESS 2007 version allredy has an integrated object from the MSCOM library that implements this function. Is it true an, if so, how can I use it to produce the code? Many thanks. Rui
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
6 Comments
Active today
I don't have experience with this myself, but some info available at these links:
http://msmvps.com/blogs/access/archive/2009/06/14/an-older-version-of-mscomm32-ocx-has-had-the-quot-kill-bit-quot-flag-set.aspx
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24371798.html
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24557032.html
~bp
http://msmvps.com/blogs/access/archive/2009/06/14/an-older-version-of-mscomm32-ocx-has-had-the-quot-kill-bit-quot-flag-set.aspx
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24371798.html
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_24557032.html
~bp
Active today
What is "AXCOM"? Do you mean the mscomm32.ocx control, or are you referring to something else?
I can assure you that Access does not have an "integrated object" that will allow you to interact with USB or Serial ports. You can use the API to do so, but it can get to be a very dicey prospect.
Does your instrument come with any programming instructions or examples? Generally those sorts of things would be included with your instrument, or would be available through the support division of the manufacturer.
I can assure you that Access does not have an "integrated object" that will allow you to interact with USB or Serial ports. You can use the API to do so, but it can get to be a very dicey prospect.
Does your instrument come with any programming instructions or examples? Generally those sorts of things would be included with your instrument, or would be available through the support division of the manufacturer.
Thank you for your kind and quick answers.
In fact, I'm refering to the MSCOMM32.OCX control. axcom is the name that ACCESS uses by default to the control when it is included in a form.
In fact I'm allready using the MSCOMM32.OCX object to transfer data between the instrument and the ACCESS database. The problem stands when I need to use the 2007 version and not the 2003 version.
The instrument is an Yokogawa power analiser and it has no additional software to implement this communication. The supplier was allready contacted and he has no device driver to make possible in an easy way the communication through the serail port. So I had to devellop the code to transfer data from the instrument to the database and it works correctely using the MSCOMM32.OCX object. But when I want to use the ACCESS 2007 database it does not work at all and generates an error because it does not recognize the refferred object.
Do you have a solution for this communication on an ACCESS 2007 databse?
Thank you in advance for your kind attention.
Rui
In fact, I'm refering to the MSCOMM32.OCX control. axcom is the name that ACCESS uses by default to the control when it is included in a form.
In fact I'm allready using the MSCOMM32.OCX object to transfer data between the instrument and the ACCESS database. The problem stands when I need to use the 2007 version and not the 2003 version.
The instrument is an Yokogawa power analiser and it has no additional software to implement this communication. The supplier was allready contacted and he has no device driver to make possible in an easy way the communication through the serail port. So I had to devellop the code to transfer data from the instrument to the database and it works correctely using the MSCOMM32.OCX object. But when I want to use the ACCESS 2007 database it does not work at all and generates an error because it does not recognize the refferred object.
Do you have a solution for this communication on an ACCESS 2007 databse?
Thank you in advance for your kind attention.
Rui
Active today
mscomm32.ocx is not now (and never was) certified to work in the Access environment. That you got it to work at all was sheer luck, and as you move forward into new Office versions and Windows platforms, you'll find that the older ActiveX controls don't work as planned (if at all).
In short - you shouldn't be using this control in Access. I know that it worked in earlier versions, but that was just pure luck. If you simply must, then switch platforms to one that is compliant with the control (like VB6) and use it there.
You can try moving the control to the Windows/System32 folder of the machine with 2007 and registering it. This might work, although it's a dodgy solution at best.
Here's a good bit of info on moving away from that control:
http://www.granite.ab.ca/access/serialport.htm
In short - you shouldn't be using this control in Access. I know that it worked in earlier versions, but that was just pure luck. If you simply must, then switch platforms to one that is compliant with the control (like VB6) and use it there.
You can try moving the control to the Windows/System32 folder of the machine with 2007 and registering it. This might work, although it's a dodgy solution at best.
Here's a good bit of info on moving away from that control:
http://www.granite.ab.ca/access/serialport.htm
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 1 hour left to enroll
622 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.