Connection String to remote Access database

[Tom Grillot]

I'm trying to write an ADO connection string that will connect to an Access
2002 database located on a web-hosting site. I've also tried using the ODBC
Data Source Administrator, an ADODC control and a Data Environment wizard in
VB6, all to no avail.



Here are some sample parameters:



Domain name: "myname.biz"

IP address: "11.222.333.444"

Database name: "mydb.mdb"

System database: "secured.mdw"

Database user name: "Admin"

Database password: ""

Path of database: "\folder1\"

In other words, database and system db are located at
"myname\folder1\"

Or, "11.222.333.444\folder1\"

Let's assume that this site will eventually be password-protected with a
password of "mypw"



Can someone please help me construct the necessary connection string. And
tell me when to use back-slashes and when to use forward-slashes.

Thanks,

Tom

 

[Norman Yuan]

You cannot do that. A website is usually exposed to outside through web
server with http(s)/FPT protocol, which cannot be used for Access mdb file
connection. Access connection requires a file server. No web services
provider will expose their file server to outside publicly.

Even you can somehow connect to a file server remotely via the Internet, it
usually still not usable because of he slowness. What you need to do is to
create a web application to access data in *.mdb or other type of database.