how to delete record from system table in Microsoft access ? RRS feed

  • Question

  • how to delete record from system table  in Microsoft access like MSysRelationships..

    beacuse  i want  to drop a relation with a default value constraint in microsoft Access like {1299C617-F91E-47A5-B7DE-C8359EB6E598}


    how to delele all relationship in microsft access

    Saturday, January 2, 2016 11:44 AM


  • You can't interact with the MSYS tables, so you'd have to remove that relationship using other methods.

    You can remove a Default constraint through the interface by opening the table in Design view, clicking on the column, and then editing the Properties to remove the default.

    You can do it through code like this:

    CurrentProject.Connection.Execute "ALTER TABLE YourTable ALTER COLUMN YourField SET DEFAULT NULL;"

    I'm not 100% sure that will work, but you can try it to see.

    -- Scott McDaniel, Microsoft Access MVP

    Saturday, January 2, 2016 12:25 PM