Forum Discussion
Create Table statement not working in Access
CREATE TABLE Patient ( taxCode VARCHAR(16) NOT NULL PRIMARY KEY, name VARCHAR(32) NOT NULL, surname VARCHAR(64) NOT NULL, username VARCHAR(16) NOT NULL UNIQUE, password VARCHAR(16) NOT NULL, e...
I believe that the ON UPDATE CASCADE and ON DELETE CASCADE statements are not supported by DAO in Access.
See https://msdn.microsoft.com/en-us/library/office/ff836971.aspx
You may be able to do this using ADO
Or see alternative code at Microsoft Access tips: DAO Programming Code Examples (allenbrowne.com)
Yes, I found out you have to inject the query from the visualBasic editor and it works from there. Same with CHECK constraints. Thank you!