ok, i just found out dap's are obsolete and read the three (actually more) kb
articles about how one can configure rds and should be using asp.net instead
so i understand this is a lost cause.
so i'll just trash the idea of using dap's and will go on with my life on
another route and another technology (and another db than A2k)... thanks Ken
for your reply anyway.

"Phil" wrote:

This thread does not seem to exist???
"The URL you provided is invalid. Please correct it and
try again."


Subject: Data Source issues
From: "Ken Snell [MVP]"
Sent: 10/10/2004
1:45:25 PM

Try microsoft.public access.dataaccess.pages newsgroup!
--

Ken Snell
MS ACCESS MVP

"Philippe" wrote in
message
...
Hi,
Since i cannot find a section for 'data access pages',
here is my post here. My issue is so weird I am sure it
is a trivial one, but I am completely stuck:

I have a problem with data access pages (DAP) data
sources. The generated code in my DAP's reads (portion
of):


a:ConnectionStringProvider=Microsoft.Jet.OLEDB.4 .0;User
ID=Admin;Data Source=C:\myfolder\mydb.mdb;Mode=Share
Deny
None;
etc...

A preliminary comment: I have read extensively web pages
from MS and other sources, and everywhere it is said to
use a URN or a URL for the data source statement. But i
am still hitting the wall: every time I try to indicate
a
different data source than the original data source (my
db on my c:\) in the Properties of the DAP, my access
2002 (office XP develper) crashes, and tells me that
nothing can be located anymore, that save mode is
disabled, and that i should re install office xp
developer... note: I trust i am current with all SP's
including WXP Pro SP's. Now here are the tests I have
performed:

1. when I run my DAP on my development pc, the mdb
indicated in the 'data source=' statement is of course
found and the data access page yields its results (it is
a report saved as a data access page)...

2. when I push my DAP on my staging web server, and
access the data access page from my pc over the
Internet,
of course the mdb found is the one from my C: drive too
on my development pc...

3. since I read the litterature, and since my
development
machine would crash every time i try a new data source,
and since I am a stubborn and persistent kid, i then
edited the DAP on the staging web wever using notepad,
and tried various combinations: if for instance i
indicate data source=\\myserver\myshare\mydb.mdb (on the
staging server), and i open the DAP from the server's
browser itself (I have my own hardware and DNS and IIS
server running MS windows server 2003, so tecnically i
know i have the latest mdac, etc...), then it works
(because the data access page is being opened directly
on
that machine, as opposed to being opened via the
Internet, so the server's C: and other drives are being
seen). As well of course a statement such as 'data
source=E:\myfolder\mydb.mdb' (where E: is a drive
associated with the stating web server), works from the
server's browser. But does not work when i come in from
the Internet on my pc.

I tried http://www.mydomain.com/thisfolder/mydb.mdb, as
well as numerous other combinations that all kind of
make
sense to me, and then no luck... the error message 'data
provider could not be intialized', is followed by 'not a
valid file name'.

So either i am very tired, or very thick, but i am at a
loss to understand why this is happening. If i could
get
the proper syntax to input in the 'data source='
statement then i guess my problem is solved?

Thank you very much for your help.