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 ...
31st January 2008, 03:52 PM #1
- Rep Power
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:
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.
sConnString="Provider=Microsoft.ace.OLEDB.12.0;Dat a Source=" & strPath & ";Jet OLEDB:Database PASSWORD= newmarket"
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!
Last edited by ryan_powell; 31st January 2008 at 03:54 PM.
Reason: Spelling and unwanted smiley appearing
IDG Tech News
Last Post: 11th January 2008, 10:14 AM
By StewartKnight in forum Hardware
Last Post: 6th November 2007, 11:51 AM
By Uraken in forum Coding
Last Post: 11th October 2007, 12:19 PM
By Jobos in forum Web Development
Last Post: 22nd May 2007, 10:49 AM
By Halfmad in forum General Chat
Last Post: 10th April 2007, 10:18 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)