I have exactly the same problem, and have reduced the Access-2003 database to its simplest form, with a simple ASP page to display the table contents. I'm using Dreamweaver MX 2004, and have set full permissions for everyone, but it still doesn't work.
I don't think its an MDAC issue, as I'm using WinXPpro/SP2 which doesn't pemit use of MDAC (as its all apparently included).
also I could never get ASP (databaseing) and Dreamweaver working
I just write the code them test it in explorer as if live.
one thing I do is turn on IIS in XP use that as my testing computer
I have a OpenDB.inc
Dim DB ,DBPath
DBPath = server.mappath("orders\Data.mdb")
Dim connstring 'conection string
connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBPath & ";"
'RESPONSE.WRITE "** >>>>" & connstring
at the top of every page when I want to talk to the database
Then to write/get data I just do
SET RS = Server.CreateObject("ADODB.Recordset")
SQL = SQL &"SELECT Prod.*"
SQL = SQL &" FROM Prod "
SQL = SQL &" WHERE (((Prod.Sheet)='" & whereThis & "'))"
SQL = SQL &" ORDER BY Prod.Type;"
now let open it
RS.open SQL , connstring , adOpenStatic , adLockPessimistic
the HARDNEST thing to get right is the connection String write
that openDB.inc I wrote about 5 year ago and all i have to change now is the DBPATH and it works every time
as long as the database is in the same place as test / live everything should work.
Last edited by myle; 07-09-08 at 20:48.
hope this help
See clear as mud
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.