+ Post New Thread
Results 1 to 1 of 1
Web Development Thread, Open password protected access 2007 database with ASP in Coding and Web Development; Hi, I have been opening password protected access 2003 databases with ASP / ADO for years now. However now we ...
  1. #1

    Join Date
    Aug 2006
    Location
    Notts
    Posts
    38
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Open password protected access 2007 database with ASP

    Hi, I have been opening password protected access 2003 databases with ASP / ADO for years now. However now we have updated to office 2007 everything gone bottoms up.

    I have an access 2007 database (newly made, not converted from 2003), and a fresh asp page. I've gotten the new connection string information for Access 2007 from the internet yet the page cannot open the database.

    connection string being used:
    sConnString="Provider=Microsoft.ace.OLEDB.12.0;Dat a Source=" & strPath & ";Jet OLEDB:Database PASSWORD= newmarket"
    When I try to open the page the error i get is - "Not a valid password" - 80040e4d. I'm 100% sure the password is correct, the driver is right (the server has office 2007 installed, and the new access driver from the M$ website). Every page i've seen on the internet says that the code I'm using is correct, yet asp still can't open it.

    If i remove the password from the database it opens fine, so it's not a corrupt database, or bad path in the code.

    If you can shed any light on my problem I would be eternally grateful - been working on it for hours now!

    Many thanks
    Ryan
    Last edited by ryan_powell; 31st January 2008 at 02:54 PM. Reason: Spelling and unwanted smiley appearing

SHARE:
+ Post New Thread

Similar Threads

  1. school password protected pictures
    By selu in forum Windows
    Replies: 3
    Last Post: 11th January 2008, 09:14 AM
  2. Password Protected Hard Drive
    By StewartKnight in forum Hardware
    Replies: 19
    Last Post: 6th November 2007, 10:51 AM
  3. access database
    By Uraken in forum Coding
    Replies: 0
    Last Post: 11th October 2007, 11:19 AM
  4. Reading an Access database with .Net 2.0
    By Jobos in forum Web Development
    Replies: 2
    Last Post: 22nd May 2007, 09:49 AM
  5. Replies: 42
    Last Post: 10th April 2007, 09:18 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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