Making Data Access Pages Location Independent

[Dave D]

I'm using Access 2000 to build a Data Access Page. I don't know much about
HTML or how web pages "talk to" databases. My problem is that when I move
the MDB and HTML files to the web or even to another folder on my PC, the
HTML file can't find the MDB file. I think this is because Access hard
codes the MDB file's location into the HTML file. I see a lined that looks
like this:

....Data Source=C:\MyFolder\MyDatabase.mdb...

I think that somehow I have to change this to something that is location
independent. Is that right? Does anyone know how to do this?


-- Dave

 

[Bonnie Snider]

After you move the data access page, when you go back into
access and try to bring it up it will tell you it has
moved and ask if you want to try to find it again. If you
say yes it you can search for it and re-associate it.

 

[Dave D]

I'm using Access 2000 to build a Data Access Page. I don't know much about
HTML or how web pages "talk to" databases. My problem is that when I move
the MDB and HTML files to the web or even to another folder on my PC, the
HTML file can't find the MDB file. I think this is because Access hard
codes the MDB file's location into the HTML file. I see a lined that looks
like this:

....Data Source=C:\MyFolder\MyDatabase.mdb...

I think that somehow I have to change this to something that is location
independent. Is that right? Does anyone know how to do this?


-- Dave