Wrox Programmer Forums
|
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 5th, 2005, 04:19 AM
Authorized User
 
Join Date: Apr 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default VB xml Programming

Hi All
I've got a financial app that i'm writting and use a microsoft access database but find the updates to access somewhat slower.

Can someone please point me to a site where i can find info on how to use xml with vb, i.e. when the user makes an invoice how should i use it with xml and then later update to access.

Regards
Helga

Helga Anagnostopoulos
__________________
Helga Anagnostopoulos
 
Old April 5th, 2005, 11:44 AM
Friend of Wrox
 
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Access doesn't really play all that well with XML. If you are going to do updates of Access where the new information is stored as XML, you are going to have to “roll your own” XML parsing code... (You might be able to find something on the web that someone else has written though.)

Since you are working with a limited set of operations (I presume), you will only need a limited set of XML handling routines.

But really, unless you need to use this XML for some other purpose additionally, you would probably be much better advised to save your invoice data in one of the formats that Access reads natively.

    1) A small Access DB that just holds the day’s transactions.
    2) A comma-delimited file
    3) A fixed-length field file

Then you could use Access’ built in ability to read that sort of file when updating the main Access db.
 
Old April 10th, 2005, 11:03 AM
Authorized User
 
Join Date: Apr 2005
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Brian

thanks for your reply. quess i'll have to do with what i've got:-)

Helga Anagnostopoulos





Similar Threads
Thread Thread Starter Forum Replies Last Post
PDA programming using VB 05 olink Visual Basic 2005 Basics 1 March 23rd, 2007 01:52 AM
Start Programming in VB.NET reality_42000 VB.NET 2002/2003 Basics 2 October 18th, 2006 05:40 AM
Programming in Access Using VB bell Access VBA 7 November 4th, 2004 06:12 PM
About XML-DSO on IE5 programming reference qualsn Wrox Book Feedback 1 December 5th, 2003 10:13 AM
VB.NET Game Programming opportunities! brodel VB.NET 0 September 20th, 2003 08:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.