Accessing Access with IIS

  • Thread starter Thread starter demvin
  • Start date Start date
D

demvin

Hi, I have run into a bad problem and hope you can help me
out, my customer sent me an access97 DB that I need to
access through Active Server Pages. I have made a system
DSN that points to it, but whenever I try to execute a
query on it, I get :
=;[Microsoft][ODBC Microsoft Access Driver] Record(s)
cannot be read; no read permission on '<table name>'.

My customer told me he has removed all security from the
database.
The only way I got it to work was to convert the DB into
Access 2003 format and reassign object peremissions cause
it seems they are not correct by default.
My connection string is : "dsn=biens;uid=;pwd=;"

Thanks a lot for your help.
 
First of all I_USR must have read, write, and delete permissions on the
database folder. Second, here's a working connection string for a JET 4.0
(Access 2000) database:

<%
dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
'oConn.connectionString=
oConn.open "DSN=biens"
'oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
' "Data Source=c:\inetpub\database\DataTables.mdb;" & _
' "User Id=admin;" & _
' "Password="

%>

Notice that User ID = admin. Admin is the default user for an unsecured
Access database. I haven't ever written one for Access 97, but I imagine it
would be similar for ODBC. Check Carl Prothman's site for practically every
possible connection string:

http://www.able-consulting.com/ADO_Conn.htm

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top