How to: Update Access database via internet

[PraveenMenon]

Hi all,

I have a problem now. The thing is, i am trying to make an application (Addressbook) that has an access backend and a VB front end. The .mdb is located in a freeserver webspace, and i don't know how to connect to it. What i need is a way to update, delete, edit or add records to the database via the VB front end and the internet. Do you people have a snippet or a helpful link or a connection string code to achieve this?

Thanks in advance,
All the Best
Praveen Menon
pcmin@rediffmail.com

 

[elvenmaiden]

ASP would help - try a weekend book course in ASP

 

[CasperTFG]

VB .NET also Craig, mailto:sander@cogeco.ca

Si hoc legere scis, nimis eruditionis habes

 

[PraveenMenon]

thanks for the reply eleven maiden and craig... but we cant do it from native VB programming? Not by using I-Net contols and webbrowser? Is there anyone who can drive me in the right direction? All the Best
Praveen Menon
pcmin@rediffmail.com

 

[jlgdeveloper]

Praveen

The above are suggesting that you create a web application...ie a private website where you do exactly what you mentioned. It is the way to go..thats how tek-tips works and everything else on the web. They all manipulate a database.

The value of your learning this (through asp pages) will benefit you tenfold. The pain of deploying a vb front end is huge...when on the web, any pc with a browser is good to go, no deployment. Tons of other reasons. Visit the asp side of technet.

I use the web 90% of the time, and use vb dll's and services to back-up the web apps. This allows a 1 user app to become 1000 user app with no painful deployment. When you make one change, you do not have to update 1000 machines...just the one web app.

There are ways to connect your vb app to the .mdb over the web. Use a dsn, substitute the url for the //computername// ...first make that work in a local network. Jonathan Galpin

http://www.iqzero.net

http://www.keen.com/categories/categorylist_expand.asp?sid=5215353&gid=0&pmode=0

 

[PraveenMenon]

Jonathan,

Thanks for the response.It is surely a way to go. But this is the requirement for the project. Am supposed to manipulate the database via the net, from a native VB application. I know this can be done via ASP or ASP.Net. cos i've been working in both of 'em. Since the client wanted the registered user of his website to download a samll app, and then do some stuff with it when the user is offline, and then update the database with a single click, from the downloaded exe. I think it is possible with the I-Net transfer controls in VB. Am still workin on it... I'll let all you guys know how it is done.

Thanks again Jonathan... Still waiting for suggestions if any... All the Best
Praveen Menon
pcmin@rediffmail.com

 

[Eldaria]

Do you have access to have a application on the server computer?
In this case you could make some kind of Client server application.
If not, then you can still use ASP, just have your application send HTML requests to the web server.
Eldaria

http://www.eldaria.net

That was my 25cent** of opinion.

** Inclusive Intrest, tax on interest, Genral tax, Enviromental tax, Tax, and tax on intrest, tax on fees, tax on tax, and other Various taxes and fees.