DB Access on the web

[Guy Detienne]

Hi everybody ;O)

Just a simple question (but hard for me):

I have an application - FrontEnd (coded with VB) installed
on a PC.
Is it possible to connect this application to one dB
Access hosted on the Net?

In fact, I do not want to pass by a Web site created with
Active Server Page but to have a frontend developed in VB
or Access on a local PC.

If it's possible, thank you for all the infos which you
will be able to transmit to me.

Thank you

Guy DETIENNE

 

[Larry Linson]

It is not practical to access a file-server database via the Internet,
because too much information has to be passed across (potientially 'way too
little) too little bandwidth. You could, possibly, get satisfactory
performance from an Access or VB client application, accessing a server
database in this manner, but security considerations usually rule this out,
as well.

If all conditions are right: your application is sufficiently simple, the
server runs Windows, and all the potential clients use IE 5.5 or later, and
all either have full Office installed, or download some software from
Microsoft, you might be able to use Data Access Pages created with Access...
but that, of course, isn't what you want, either.

Larry Linson
Microsoft Access MVP

 

[Nic]

If the database is on the net, and you want to be able to access the data
via your VB application, then I think you want to look into Web Services.

Web Services are like functions you can access via http. do a search on
google for them.

-Nic

 

[Guy Detienne]

Many thanks for your answer

It is not practical to access a file-server database via the Internet,
because too much information has to be passed across (potientially 'way too
little) too little bandwidth. You could, possibly, get satisfactory
performance from an Access or VB client application, accessing a server
database in this manner, but security considerations usually rule this out,
as well.

If all conditions are right: your application is sufficiently simple, the
server runs Windows, and all the potential clients use IE 5.5 or later, and
all either have full Office installed, or download some software from
Microsoft, you might be able to use Data Access Pages created with Access...
but that, of course, isn't what you want, either.

Larry Linson
Microsoft Access MVP

 

[Guy Detienne]

Many thanks for your answer

If the database is on the net, and you want to be able to access the data
via your VB application, then I think you want to look into Web Services.

Web Services are like functions you can access via http. do a search on
google for them.

-Nic