What's the next step...connect to db in web folder

[Mal]

Hello.

I created an ASP page that stores survey data in an Access database on
my website.

This all works well.
I can copy the database to my local machine and then use it for all
kinds of reporting purposes.

However...

How do I link directly to the tables online??
When I go through my local front end - import data - link tables.
I get an error about unknown file name or no permission.

What's the next step??

Mal.

[Trevor Best]

Mal wrote:

Hello.

I created an ASP page that stores survey data in an Access database on
my website.

This all works well.
I can copy the database to my local machine and then use it for all
kinds of reporting purposes.

However...

How do I link directly to the tables online??
When I go through my local front end - import data - link tables.
I get an error about unknown file name or no permission.

What's the next step??

Create more ASP pages, you cannot link directly to a web server using http.

--

\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\

[Mal Reeve]

I don't want to use http.
I want to have my local DB use the tables in the online DB as linked tables.

how??

Mal.

"Trevor Best" <nospam@localhost> wrote in message
news:41***********************@auth.uk.news.easyne t.net...

Mal wrote:

Hello.

I created an ASP page that stores survey data in an Access database on
my website.

This all works well.
I can copy the database to my local machine and then use it for all
kinds of reporting purposes.

However...

How do I link directly to the tables online??
When I go through my local front end - import data - link tables.
I get an error about unknown file name or no permission.

What's the next step??
Create more ASP pages, you cannot link directly to a web server using

http.
--

\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\

[Trevor Best]

Mal Reeve wrote:

I don't want to use http.
I want to have my local DB use the tables in the online DB as linked tables.

how??

I just told you, you can't do that. You want the moon on a stick you do :-)

The next best thing would be to have Access and Terminal Server
installed on the web server, everything would be local to the server and
the MDB on your local machine would be redundant.

--

\\\\\\
\\ \\ Windows is searching
\ \ For your sig.
\ \ Please Wait.
\__\