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.
"Tom Grillot" <(E-Mail Removed)> wrote in message
news:6L%fh.5723$(E-Mail Removed)...
> 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
>
>
|