Yes, you can do this, I have an operation program that reads and writes an Access Database from a UV Basic program. I am attaching a sample program that shows the techniques written under Universe. I had to change the code to remove any proprietary information, but you should still be able to follow the logic of reading and writing to an access database. One caveat, this was written to work with UV on Windows. I believe that this should work on Unix too as long as ODBC has been configured. You will also need to setup an odbc data source on the client that points to your Access database. In this program that is call "SOSHIP" and is referenced in the MDB.CONNECT subroutine. Sorry I don't have an example of that, but if you have trouble post back an I will dig in some more.
Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 25, 2004 9:33 AM To: [EMAIL PROTECTED] Subject: [U2] connect to an access database Hello all, Is anyone familiar with a way to connect an MVBasic app to an access database or datasource ? I need to be able to read/ write to/from a specifiac datasource. Is there a way I can connect from within a UV app to another datasource via ODBC ? Any transport will do really. I was thinking of writing an outside app to do the data connection to pass and retr for the uvapp but if theres a more direct approach from the MVApp itself, I'm wide open to suggestions. Thanks in advance, Vance ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of ACCESS DATABASE CODE] ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
