SQL Server Performance Forum – Threads Archive
Microsoft Access 2002 problem
Hi I have some problem about ASP and Microsoft Access 2002. I just installed Microsoft Access 2002. I use IIs to run ASP. When I wrote Select method. There is no problem. But the problem is when I wrote Delete method I got message "Could not delete from specified tables."and when I wrote update method I got message "Cannot update. Database or object is read-oject." Please help
One more thing sometime I got message connect.asp could not use "; file already in use.
This is my connect.asp file
<%
set conn=server.createobject("adodb.connection")
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&server.mappath("db1.mdb")
%>
I think this file don’t have a problem because when I use with Microsoft access 2000 there is no problem. I think the problem i smicrosoft access 2002
Have you checked the file and NTFS permissions on the access database to make sure that it is not set to read-only and that the user has the modify permission…? Also in Access you can set whether the file is opened exclusively or not, so may be worth checking those too Cheers
Twan
I’ve also got these in the past. I also think you have to give required permission sometimes need to give FC permission. AKTHAR DILMOHAMUD
65 BENARES ST
PORT LOUIS
MAURITIUS
try to delete the rows from access 2000 DB itself to confirm whether its read only or not.
Try to create table objects too.
Have u copied it from CD
http://support.microsoft.com/kb/240098/
says to Set the UniqueRecords property of the query to Yes. To set the UniqueRecords property of the query to Yes
UniqueRecords is needed for Jet-SQL delete query with multiple tables in the FROM clause, where you need to add the DISTINCTROW keyword (same as setting the property on the graphic representation of the query). As long as you’re using ADO you can ignore Jet-SQL idiosyncrasies. "Database or object is read-only" can have a whole lot of reasons, most important ones are Service Pack related. Do you have the latest MDAC version installed? (2.8, I think) Also, with MDB files you may need to refer to a specific MDW file with a user name and login to have permissions (a.k.a. System DB or workgroup file). If you don’t specify the workgroup, ADO will use the default file System.MDW and attempt to connect as user Admin with a blank password. The MDB file may have been setup with no permissions for user Admin, and none for the user group Users – both common security measures in the Jet world.
>>when I wrote update method I got message "Cannot update. Database or object is read-oject." sounds that the Access Database is in Read-only mode Madhivanan Failing to plan is Planning to fail
]]>