Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Data Access Page

Discussion in 'Information Technology' started by kujosventures@hotmail.com, Nov 16, 2005.

Tags:
  1. kujosventures@hotmail.com

    kujosventures@hotmail.com
    Expand Collapse
    Guest

    Dear Access Team,

    Please could anyone help me? I build data access page base on a single
    table. The page works perfectly in my Internet explorer in my laptop before
    uploading.

    After uploading I have change the Access .mdb file location as below example
    that read the location of the mdb file in my server

    <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
    Source=http://www.myservername.com/secdata.mdb;Mode=ReadWrite

    But whenever I call up the page from the Internet in my web site it does
    display the below dialog box error message consequently

    Not a Valid file Name
    Data Provider could not be initialized

    After the error it display field name with # sign in the dynamic field box

    E.g. ID #Name?

    Regards


    Taiwo (UK)
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Access doesn't recognize the HTTP protocol (nor the FTP protocol, for that
    matter). You must use a proper UNC.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "kujosventures@hotmail.com"
    <kujosventureshotmailcom@discussions.microsoft.com> wrote in message
    news:23D7F2B2-7FF4-4B8A-807E-8ECBE430FCEC@microsoft.com...
    > Dear Access Team,
    >
    > Please could anyone help me? I build data access page base on a single
    > table. The page works perfectly in my Internet explorer in my laptop

    before
    > uploading.
    >
    > After uploading I have change the Access .mdb file location as below

    example
    > that read the location of the mdb file in my server
    >
    > <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
    > Source=http://www.myservername.com/secdata.mdb;Mode=ReadWrite
    >
    > But whenever I call up the page from the Internet in my web site it does
    > display the below dialog box error message consequently
    >
    > Not a Valid file Name
    > Data Provider could not be initialized
    >
    > After the error it display field name with # sign in the dynamic field box
    >
    > E.g. ID #Name?
    >
    > Regards
    >
    >
    > Taiwo (UK)
    >
     

Share This Page