Can I use VB.net and XML to read/write a MS access database in the web-site?

[ATC]

Let say I have a web-site http://www.TrialXML.com, in that site I have a folder \database and my MS Access database file Trial.mdb having a table Purchasing and having 2 columns: Part & Value In the main folder (www), I do have the Link_XML.asp that can handle XML (Reponse & Request) will be used from the Client to access the Trial.mdb Is there any sample codes or links that I can use to write code in VB.net using XMLDOM to read/write data to the Trial.mdb through Link_XML.asp? Thanks in advanced, :doh:

[Mycroft Holmes]

I don't know a lot about the later versions of Access but what makes you think you can use XML to write to a database? You could use a CONNECTION to write xml into a database but AFAIK you can use XML.

Never underestimate the power of human stupidity RAH

[ATC]

- 4 years ago, my friends said that using XML to access information directly through the Web is much better than using program (FTP) to download files (read information) then upload files (write information). - In my question, I did mention that XML does not access directly to MS Access database, but through an .ASP file. In that ASP file, the Request XML commands will be handled and it will connect to MS Accesss database to read/write information ... then it will Response back to the Client I hope that I explain mt question well enough. There might be a better way to access data trhough the WEB without Download/Upload files through FTP?

[Mycroft Holmes]

Ok, now I get to see your problem. Actually you and your friend have a very wrong handle on how this should work. What you need to look into are database driven web pages. This is completely different to what you are thinking of. Todays structure is more like: Database - SQL Server with stored procedures to service the clients - lives near/on the web server DAL - VB project that connects yor OM to the database - lives on the web server OM - Object model - VB project that represents your objects (tables in database or entities in the UI) - lives on the web server Code behind - VB attached to your ASPX pages - lives on the web server. ASPX - UI served up by the web server to the client and uses code behind to connect to the OM which uses the DAL to connect to the database to get the data Ajax as well on the ASPX pages. So life is a little more complex than you envisaged. There are 3 distinct languages required for this development (TSQL, VB and javascript). If you are going to pursue this you should start with database design, get your data right and the rest will be simpler (not easy but simpler).

Never underestimate the power of human stupidity RAH

[ATC]

Thanks for detail explains, I think I have to change our approaches and start the way as you suggested Thanks :)