We implimented an ACESS interface as follows:
Open MSACCESS with an Execute Program object.
Write to Access using a to/from DDE object. The parameters are as
follows:
Application: MSACCESS
Topic: system
Timeout: 15
To open the database use:
EXECUTE CMND "[OpenDatabase "+YourDatabaseName+"]"
To manipulate the database in Structured Query Language
EXECUTE CMND "[runSQL ""+A+""]"
A formula builds an SQL statement that you feed into the A input of
this object.
We used the report functions in MSACCESS to generate the datasheets.
The above method was implemented in VEE 3.12, and took a lot of tinkering
and error handlers. It resulted in a very polished solution, but it took a
lot of effort. Note also that VEE briefly changes colors when ACCESS loads
An alternate method is to use Visual Basic with the Jet database engine to
write ACCESS-compatible files. It is somewhat more flexible, especially
for the user interface. Use DDE to write the data into a field of a VB
form and chew on it from there. If you carefully define the I/O interface,
the VB stuff can interface with other languages as well
>----------
>From: Greg Grenier[SMTP:ggrenier@inst-sun1.jpl.nasa.gov]
>Sent: Wednesday, December 03, 1997 3:55 PM
>To: 'VEE reflector'
>Subject: vfr
>
>Does any body know how to make VEE enter information into a Microsoft Access
>database? If so please email me at ggrenier@inst-sun1.jpl.nasa.gov
>Thanks
>Greg Grenier
>Instrument Services division
>Jet Propulsion Laboratory
>4800 Oak Grove Dr.
>Pasadena Ca. 91109
>
Jim Kneale kneale.j.b@postal.essd.northgrum.com
ph (410)765-3807 /// Northrop Grumman ESSD
fax (410)993-8126 (..) Baltimore MD USA
----------------ooO-()-Ooo------------------
#include "std_disclaimer.h" //opinions are my own
Open MSACCESS with an Execute Program object.
Write to Access using a to/from DDE object. The parameters are as
follows:
Application: MSACCESS
Topic: system
Timeout: 15
To open the database use:
EXECUTE CMND "[OpenDatabase "+YourDatabaseName+"]"
To manipulate the database in Structured Query Language
EXECUTE CMND "[runSQL ""+A+""]"
A formula builds an SQL statement that you feed into the A input of
this object.
We used the report functions in MSACCESS to generate the datasheets.
The above method was implemented in VEE 3.12, and took a lot of tinkering
and error handlers. It resulted in a very polished solution, but it took a
lot of effort. Note also that VEE briefly changes colors when ACCESS loads
An alternate method is to use Visual Basic with the Jet database engine to
write ACCESS-compatible files. It is somewhat more flexible, especially
for the user interface. Use DDE to write the data into a field of a VB
form and chew on it from there. If you carefully define the I/O interface,
the VB stuff can interface with other languages as well
>----------
>From: Greg Grenier[SMTP:ggrenier@inst-sun1.jpl.nasa.gov]
>Sent: Wednesday, December 03, 1997 3:55 PM
>To: 'VEE reflector'
>Subject: vfr
>
>Does any body know how to make VEE enter information into a Microsoft Access
>database? If so please email me at ggrenier@inst-sun1.jpl.nasa.gov
>Thanks
>Greg Grenier
>Instrument Services division
>Jet Propulsion Laboratory
>4800 Oak Grove Dr.
>Pasadena Ca. 91109
>
Jim Kneale kneale.j.b@postal.essd.northgrum.com
ph (410)765-3807 /// Northrop Grumman ESSD
fax (410)993-8126 (..) Baltimore MD USA
----------------ooO-()-Ooo------------------
#include "std_disclaimer.h" //opinions are my own