Microsoft Access 2002 problem | SQL Server Performance Forums

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") "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
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
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
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