Cascade Delete question

[AnnPhil]

I would like to delete some records in my database but the Cascade Delete option is grayed out. The tables are linked to SQL Server and have an Access front. I tried making some delete queries that would delete records from each table and that wouldn't work. Basicly I have three tables that are related and so i need to delete records form all three that are tied to one job. I have done this before in other access databases but not one tied to SQL Server. Not sure what to do, I can manually delete records so i dont think its a permissions issue.

Thanks in advance for any help

 

[georgedwilkinson]

You have to do it in SQL Server. You can use Enterprise Manager or some other tool that gives you access to the table design.

You also may be able to do it by creating an Access project (Access 2002 or greater) connected to your SQL database. Though, I haven't tried manipulating the table design from a project since I prefer the SQL Server tool set.