Both-
1. ON DELETE CASCADE
2. ON UPDATE CASCADE
give Syntax error in CONSTRAINT clause when executed. What is the mistake?
Advanced Beginner
Windows 10 
Access 2016
Both-
1. ON DELETE CASCADE
2. ON UPDATE CASCADE
give Syntax error in CONSTRAINT clause when executed. What is the mistake?
VIP
Windows 10 Office 365
What are the constraints on the tables concerned?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
VIP
Windows 10 Access 2010 32bit
Are you trying to build this SQL in query object? Review https://stackoverflow.com/questions/...delete-cascade
Post your code if you still need help.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Advanced Beginner
Windows 10 Access 2016
Thank you for the replies.
I was trying to run these DDL commands in SQL view of query. I'll try to run these in VBA.
What type of SQL commands can't be run in SQL view? Thank you again for your help.
VIP
Windows 10 Office 365
Please post the exact whole SQL statement you are using.
What you have shown so far wouldn't work, and is incomplete.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Incomplete Syntax Clause (syntax error)
Posting Permissions
Reply With Quote