Access database via internet

[slaphead109]

Using VB6, can anyone advise how to add data to tables in an access database via the internet. I can use appi's to check connections and ftp text files etc. I can connect to the database on the local machine :-

MyApp = "\test.mdb;"
myPath = App.Path
Password = "Uid=; Password = éøòðçìáú;"
strMode = "Mode=ReadWrite;Persist Security Info=False;"
strConnect = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" _
& myPath & MyApp & strMode & Password
Set cnn1 = New ADODB.Connection
'connect to database
cnn1.Open strConnect

but I am puzzled how to connect via internet.

Can anyone shed some light?

[jp140768]

This should help you out:

Article from Code Guru on Internet and DB Connections.

HTH

[slaphead109]

Thanks for the link.

I am at a non starter with it as I get an error message from the very first line "invalid use of new keyword"

I am using VB6, maybe this is for .Net?

I am very vague on the DSN, in its simplest form is this just the database name? eg MyDB.mdb

[jp140768]

Are you getting a problem on this line:

set cnnGeneric = new Connection

You may have to specify = NEW ADODB.CONNECTION.

I guess the DSN, is the address that you would use if looking at the database via Internet Explorer, but I don't know to be honest with you.

The link is for VB6 code.

[slaphead109]

You are right about the ADODB, I should have spotted that, thanks.

I now get error number 8209 Internet Server Errror:Object/Module not found

I will keep trying and if I hit lucky will post the correct string.

[jp140768]

It sounds like you have specified the location of the database incorrectly. In IIS, if you turn on directory browsing, and then use a browser to find the database, this may give you the correct location?

Don't forget to turn off directory browsing afterwards.

Alternativly, you could set up your application on the server, use something like an ASP page to update the database. You could use the ASP page to update the database via a VB DLL. I haven't done any Internet coding as yet, so this may not be as easy as I think.......

HTH

JP