ALTER TABLE problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
mishj said:
ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?
Click to expand...

Tools | Options | Tables/Queries | SQL Server Compatible Syntax (ANSI 92) |
<Check> This database.
 
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!!

Granny Spitz via AccessMonster.com said:
mishj said:
ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?
Click to expand...

Tools | Options | Tables/Queries | SQL Server Compatible Syntax (ANSI 92) |
<Check> This database.
Click to expand...
 
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
mishj said:
ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?
Click to expand...

Tools | Options | Tables/Queries | SQL Server Compatible Syntax (ANSI 92) |
<Check> This database.
Click to expand...
 
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
mishj said:
ALTER TABLE [ARTICLE]
ADD COLUMN [APPROVED] CHAR(1) DEFAULT "N"

I feel like I must be missing a patch or something?
Click to expand...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alter table and order by 1
Alter Table Question 2
Set default value to 0 with ALTER TABLE 1
ALTER COLUMN question 1
ALTER TABLE column with default value 1
alter table question 1
SQL Change Column name 5
Alter table statement 2

Back
Top