Results 1 to 4 of 4
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Data Access Pages another point to ponder (Access 2003/SP3)

    I've been following the posts on DAPs for a while now, and I have another point to add for those making a decision.

    I have been unable to find a method to alter the connection string in the DAP's I create. They reset back to the mapped network drive. There appears not to be a method to set them to a web address.
    The result? DAPs cann't be accessed by users without network access (which kinda nukes the whole web access thing in my opinion).

    Hey, I'd be happy to find out I'm wrong about this. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Be Careful What You Wish For...

    ...cos it might come true <img src=/S/yep.gif border=0 alt=yep width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/tongue.gif border=0 alt=tongue width=15 height=15>
    The following is taken from Microsoft Office Access 2003 Inside Out by John Viescas
    Chapter 27
    Part 6: Linking Access and the Web

    Publishing data access pages on the Internet
    As you already know, the connection properties of your data access pages must be defined
    so that your users can access your database from their client machines

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Be Careful What You Wish For...

    Thanks for that - I'm off to research it now!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Be Careful What You Wish For...

    There are apparently security issues (aren't there always) with activating Remote Data Services - for those who are interested, I offer the following links:
    http://xforce.iss.net/xforce/alerts/id/advise32
    http://xforce.iss.net/xforce/xfdb/1212
    http://support.microsoft.com/default.aspx?scid=kb;[LN];184375
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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