Results 1 to 8 of 8

Thread: read only problem RESOLVED

Threaded View

  1. Jun 9th, 2004, 09:48 AM #1
    peter piper
    peter piper is offline

    Thread Starter
    New Member
    Join Date
    Jun 2004
    Posts
    4

    read only problem RESOLVED

    I have an Access db with 4 tables in it which I'm accessing through vb (customers, jobs, quotes and invoices).
    I can access the customer table ok.
    The db has a query which links 3 tables together but when I try to add a new record to it using

    datJobs.recordset.addnew I get an error message

    "Run-time error 3027

    Cannot update database or object is read only."

    The db isn't read only as I can access the customers table and make changes.
    The read only property on the data object is also set to false.

    Any help would be appreciated
    Last edited by peter piper; Jun 16th, 2004 at 03:51 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width