By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,830 Members | 682 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,830 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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.
\__\

Nov 13 '05 #2

P: n/a
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.
\__\

Nov 13 '05 #3

P: n/a
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.
\__\

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.