Microsoft Access on the web...

[kimosavi]

Hi. Kind of newbie on the whole Access on the web sharing.

I am building an application in VBS. my plan is to use a small centralized Access DB as my data repository.

I need this file to be on a server which each one can connect and share.

what would be my cheapest way to do this (if possible for free)?

what code should i use to connect to this DB?

Thanks!

 

[ezfriend]

This is an ASP page that uses mdb as back-end db. Hope it helps you a little here.

<%
    DIM CONNECT,DBCONN,SQL
    'SEARCHDBPATH is a string representing where the DB resides.
    CONNECT="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(SEARCHDBPATH)

    Set DBCONN=Server.CreateObject("ADODB.Connection")

    DBCONN.OPEN CONNECT

%>

 

[kimosavi]

Thanks! it does help!

I just need know a server to put my DB. What would you recommend?

are there free servers out there where I can put my DB?

I will access the DB thru Visual Basic Application not WEB so no need to host the pages just the DB.

 

[ezfriend]

I have never done it that way, but it would be interesting to find out.
I'll do some research and if I find anything, I'll post it here.

Good luck on your search too.