Download Access db from hosted site

[FatJackSprat]

I have an online database with info entered by visitors: name, city, etc.

My web host told me that I can't connect directly to the database. Then he said that I can download the database directly to my hard drive through the use of scripts, but he isn't able to give me any info about how to do it.

I have been searching and can't find anything.

The setup I would like to have is:

Visitor enters info in text boxes > info stored in online db > I download db to my hd

Thanks.

 

[BFG10K]

Have you tried making a data access page in Access?

 

[EagleKeeper]

Originally posted by: FatJackSprat
I have an online database with info entered by visitors: name, city, etc.

My web host told me that I can't connect directly to the database. Then he said that I can download the database directly to my hard drive through the use of scripts, but he isn't able to give me any info about how to do it.

I have been searching and can't find anything.

The setup I would like to have is:

Visitor enters info in text boxes > info stored in online db > I download db to my hd

Thanks.

Arrange to get the file via FTP.

Access database are a single .MDB file.

 

[Codewiz]

So you can have a script that enters data into the database but you can't have a script that displays it? Something isn't right here.

 

[EagleKeeper]

Originally posted by: Codewiz
So you can have a script that enters data into the database but you can't have a script that displays it? Something isn't right here.

The OP may want to grab the complete database not just fields of data.