Constraint Syntax Error?

  • Thread starter Thread starter Özden Irmak
  • Start date Start date
Ö

Özden Irmak

Hello,

I got syntax error on this constraint clause pointing the [NO INDEX] :

ALTER TABLE [Title Author] ADD CONSTRAINT
[{BD291498-E5FD-11CF-80D3-00AA00C0094F}] FOREIGN KEY [NO INDEX] ([ISBN])
REFERENCES [Titles] ([ISBN]);

According to Jet Sql 4.0 reference this should be working.Anyboy can help
me?

Thanks in advance,

Özden
 
You might try:

ALTER TABLE [Title Author] ADD CONSTRAINT
[{BD291498-E5FD-11CF-80D3-00AA00C0094F}] FOREIGN KEY NO INDEX ([ISBN])
REFERENCES [Titles] ([ISBN]);

In other words, remove the square brackets around "NO INDEX".

Also, you have to execute statements with the "NO INDEX" keywords through
the Jet OLE DB Provider -- for example, using
CurrentProject.Connection.Execute.
 
Back
Top