How can LabVIEW press a command button in access form?

[TobSTAR]

Situation: access database with a command button, who generate a code after pushing

Task: LabVIEW open the access database, pressed the command button and read out the code

Status:

• use activeX to open the access database - ready
• press the command button - open
• read out the code - open

Problem: Is there a possibility that LabVIEW press automatically the command button in the access form?

[mikeporter]

First off, you are confusing your terms. Access is not a database. It's an development environment for creating applications that use databases. By default, Access uses a DBMS called Jet that is built into Windows, but it can use others like SQL Server or even Oracle.

Second, in terms of pushing the button, that is totally dependent upon what functionality Access' ActiveX interface chooses to expose to external applications.

Third, what does the button actually do? The statement, "..generate a code.." is meaningless. Does it perform a query? Does it generate a report? Does it modify records?

Mike...

[TobSTAR · Accepted solution]

Dear Mike,
thx for reply. You are right MS Access is really not a database. 😉

When the operator will push the button the programm generate a serial number and add the new number in the article table.
So pushing button means process this code.

Solution
After I became the password, to unlock the database, I check the code behind the button and build this with LabVIEW.

So it is not necessary to push the button 🙂

[mikeporter]

Yes! That is what I was leading to with my question about what the button actually does.

Mike...