Results 1 to 3 of 3

Thread: Data Access Page in VBA for MS Access

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Aug 2001
    Location
    new jersey
    Posts
    2,904

    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

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333
    Check MSDN to see what you can find on a Data Access Page.

    http://msdn.microsoft.com/

  3. #3
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width