Data Access Page in VBA for MS Access

I have successfully created a DAP in Access 2000 but I can't get it to point to the db on a server, except as a local file. That is, if I tell the DAP that the Data Source MDB file is at "C:/ ... " on the server, then it works just fine, but then the DAP can't be used over the internet, and if I tell the DAP that the Data Source is "//802.23 ... " then the DAP comes up over the internet but won't connect to the MDB file. I get a message saying "invalid path" & I've tried every path construct I can think of with no joy.

Other files on the same server are readily accessible using similar paths, but they have the "http:" at the start --- I've also tried this in the DAP but it doesn't work either.

SO ... my question is how the dickens do you get a DAP on a server to point to the db on the server so the DAP can be used over the internet?

thanks for any help.

Paul Hinds

Check MSDN to see what you can find on a Data Access Page.

http://msdn.microsoft.com/

I reckon you'll need to post in ASP forum this seems like an ASP problem!
I think the DAP was only designed local intranets i dont think you can tell it too access using an ip address wihtout knowing some ASP and altering the code!

I'm sure Sastraxi or JoshT may know!