Sean, My first question would be does this code work correctly on your development machine? I would hope that no hosting company is going to let you "test" development code on their production servers. I would also hope that no professional developer here would expect that from any hsoting company. The problem is not too hard to pinpoint but it would help everyone greatly if you provided the platform, MDAC Version and Access Version you are using. The problem here is almost certainly the permissions on the folder containing the Access database. The folder must have both read, write and update permissions. We are a hosting company and strongly discourage the use of Access on a production Web site. Anyway, have the permission changed and your queries should work. If you want a great hosting company that realyy know what's going on when if come to ColdFusion hosting and development, give us a call. Creative Data Concepts - http://www.creativedata.net Jim ---------- Original Message ---------------------------------- From: "Sean Blenkhorn" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 23 Nov 2000 15:16:06 -0500 > >Hey gang... > >I am trying to host my site with CIHost in Texas I believe... and I have >been plagued with problems trying to get the site running. Here is the most >recent problem I have been seeing... > >Error: >[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable >query. > > >It seems that my SELECT statements work, however my UPDATE statements do not >work. They seem to think it is my problem, I seem to think it is a >configuration problem on their end... but no one really knows what exactly >is wrong... can anyone pinpoint the problem for me?? Is this a permissions >problem? > >Any help would be greatly appreciated! > >Sean > >P.S. I would NEVER recommend using CIHOST for any Cold Fusion hosting!! > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/[email protected]/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
