I want an example about manipulate MS Access

[tyro]

From message i have seen I know i must create a .fp through ActiveX, I
tried many times ,but failed,who can give me an example(full project).
thanks.

[Triffid]

1. Walk

2. Run

🙂

"tyro" wrote in message
news:e8cce840.0208130336.3c924c73@posting.google.com...
> From message i have seen I know i must create a .fp through ActiveX, I
> tried many times ,but failed,who can give me an example(full project).
> thanks.
>

[DanielMcchane]

Under your project window for CVI, go to the menu bar and select the TOOLS >> CREATE ACTIVEX CONTROLLER option. This wizard will look for the registered ActiveX Automation servers on your system. Select the Microsoft Access one, and the .fp file should be built for you from there. The .fp includes the source code and the header file for the instrument (Access). I have attached one that I've made here.

Daniel McChane
Application Engineer
National Instruments

[zotamus]

Hello Daniel,

Can I use this MsAcess fp example you talked about to open a database, and update a table (write a record).  I have been trying to figure this out for a couple days now.

Thanks,

Zot

[JonathanN]

Howdy Zot,

The ActiveX controller wizard generates a new instrument driver for an ActiveX server which in this case is Microsoft Access. Whatever Microsoft exports to use as server properties is what we can manipulate. Take a look at the Microsoft Access Object Library reference on MSDN to see what properties and methods Microsoft exports. 

You may want to consider purchasing the LabWindows/CVI Enterprise Connectivity Toolkit which provides SQL tools for database connectivity. 

Also to, you may want to check out this forum that provides some other insight into this issue. From what customer's have mentioned in that forum, it appears Microsoft does export the capabilities to create queries and access databases.

Hope this helps!

Best Regards,