ALTER TABLE problems

[Guest]

I have an alter table statement that I swear worked in Access 2000 but doesnt
appear to work in 2003? Help!

ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?

 

[Granny Spitz via AccessMonster.com]

ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?

Tools | Options | Tables/Queries | SQL Server Compatible Syntax (ANSI 92) |
<Check> This database.

 

[Guest]

Wow! Thank you! You are a genius! I would never have found that without you
- it didnt appear under any of the (hundreds of) searches I have done on
msdn, microsoft.com, google groups etc etc!! Thanks SO MUCH!!

ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?

Tools | Options | Tables/Queries | SQL Server Compatible Syntax (ANSI 92) |
<Check> This database.

 

[mishj]

THANKS SO MUCH! This solved an issue that had been bugging me for ages
- I looked everywhere for an answer but could not find one! This
worked!!!

It is maddening that this option is so hidden and its so difficult to
find out why standard sql no longer works by default in Access!!

Thanks
Michelle

ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?

Tools | Options | Tables/Queries | SQL Server Compatible Syntax (ANSI 92) |
<Check> This database.

 

[mishj]

THANKS SO MUCH! This solved an issue that had been bugging me for ages
- I looked everywhere for an answer but could not find one! This
worked!!!

It is maddening that this option is so hidden and its so difficult to
find out why standard sql no longer works by default in Access!!

Thanks
Michelle

ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?

Tools | Options | Tables/Queries | SQL Server Compatible Syntax (ANSI 92) |
<Check> This database.

 

[Granny Spitz via AccessMonster.com]

Wow! Thank you!

You're welcome! I'm pleased I could help.

You are a genius!

Thank you, but I just play one on TV. <g> It's the writers that make me
look good!