SQL Server Performance

Microsoft Access 2002 problem

Discussion in 'Non-Transact SQL Developer Performance Tuning' started by gop373, Sep 30, 2004.

  1. gop373 New Member

    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
  2. gop373 New Member

    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

  3. Twan New Member

    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
  4. Akthar New Member

    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
  5. ranjitjain New Member

    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
  6. dineshasanka Moderator

    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

  7. Adriaan New Member

    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.
  8. Madhivanan Moderator

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

Share This Page