OK, i'm just a beginner at this SQL & ASP stuff, so bear with me.

I have uploaded a ms dbase to my server. Upon completion of the site, i noted that i could not update the database or add new records. I have read numerous pages on changing the IUSR user to have read/write/execute permissions. This does work because i designed another site, in which i requested that the permissions be changed, and everytyhing worked just fine. The problem this time is that the server admin will NOT change my permissions becuase it compromises security. Now I'm left trying to find a work around for this problem. My server has an ODBC function on their control panel, but I am unsure how to use it. I have just used an OLEDB with the JET engine to connect.

I'm using Dreamweaver MX.
Here is the exact "connect" file that dreamweaver generated based on my custom connection string to the dbase:

<%
// FileName="Connection_ado_conn_string.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="true"
// Catalog=""
// Schema=""
var MM_dbs_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +Server.MapPath("/cjm/updates/dbase.mdb"+";user id=; password=;"
%>

And here is the execute statement on the record update page.

// execute the update
var MM_editCmd = Server.CreateObject('ADODB.Command');
MM_editCmd.ActiveConnection = MM_editConnection;
MM_editCmd.CommandText = MM_editQuery;
MM_editCmd.Execute();
MM_editCmd.ActiveConnection.Close();

I get the error on the line corresponding to the "MM_edit.Cmd.Execute()" command.

One Other question?? Does setting the security on the folders on the local side have anything to do with the permissions after it is uploaded to the server?

Any assistance would be greatly appreciated!!

You will need to have the server admin to set write permissions for the /cjm/updates/ folder at the server. There is simply no other way. The server admin you use, if it's this guy or any other, need to set permissions for you. You cannot do this yourself, through programming, as it would be a security hazard.

No, unfortunately, the permissions would have to be set for the folder at the server. Transfering a folder doesn't transfer it's permissions.

Can you use the same folder you used for the site where it worked, at this site too? That folder has the correct permissions.

My administrator told me that he did set the folder for write permissions. However, the update still does not work. I'm not sure if he did it correctly, or maybe something else needs to be enabled. Does it mean anything that the execute line gives me the error? Does execute permissions need to be enabled too?

I also tried doing it their way also, i created a DSN with their control panel (not the preferred method), and it still didn't work. I get exactly the same type of error "updateable query". Is there any other workarounds to this that you might know of? Possibly different Connections?

FYI - the host i am using is hostonce.com. I have not been thoroughly impressed by their service, but they are dirt cheap. It does me no good though if I can't run dynamic sites.

As far as I know, the administrator has to set write-permissions if you want to run an update-query, since you're *writing* in the database.

You should be able to use the connection string you're using, although I'm assuming you acctually got something at username/password <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> You're able to extract data from the database?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
OK, i'm just a beginner at this SQL & ASP stuff, so bear with me.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I know this post is old, but for any that come across it and have tried changing the permissions and nothing is working, I have something that just helped me after being frustrated for 4 hours with this problem. This is especially for us lazy Dreamweaver users:

Make sure your recordset contains all the fields you are trying to update, or just use the select all option when you are setting your record set up. It makes for a much happier day!

Edited by - dannyyoder1978 on 04 Oct 2006 17:12:53