[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Writing to Access Files (OpenInsight Specific) ====
=== At 29 APR 1998 06:35:19AM Peter F wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
Is it possible to write directly into Access files?



If so is there any easy to follow documentation?
</QUOTE>
----

=== At 29 APR 1998 09:45AM Dave Pociu wrote:  ===

<QUOTE>Yes, 



You can use the C/S part of OpenInsight to set up an ODBC connection with an ACCESS database. The best documentation I have seen on this so far (for beginners) is in Sprezzatura's latest newsletter (S/ENL volume 2 issue 1. 

Go to www.sprezzatura.com and download it. It's free.



For more involved ODBC work, look at the warehousing documentation (and source code) in OI.



Good Luck!

</QUOTE>

----

=== At 29 APR 1998 03:57PM Peter wrote:  ===

<QUOTE>Dave 



Thanks - The Good Luck bit sounds a bit ominous.





Peter

</QUOTE>

----

=== At 29 APR 1998 10:28PM Dave Pociu wrote:  ===

<QUOTE>No, no, no :)



It's just that it's a little bit of a shift from the Linear Hash way to the ODBC way! 



Manageable though... I should wish you "fast learning"! Better ?

</QUOTE>

----

=== At 30 APR 1998 07:15AM Cameron Revelation wrote:  ===

<QUOTE>Peter,



Look up QryMethod in the help file and take a look at the example code in there.  To work with Access data, you must use SQL scripts, and the easiest way is with the QryMethod QRY_EXECUTE$.



Cameron Purdy

Revelation Software

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=D7A346278264D1BE852565F5003A2A83|View this thread on the  forum...]]