I want to add a column in Orders databasen

I want to add a column in Orders but I cant.

Could someone show me how to do it?

It should be a column called Visible
The type should be Boolean or YES/NO

Nwind.mdb
MickeysAsked:
Who is Participating?
 
pcelbaConnect With a Mentor Commented:
The new column is there. Access 2007 allowed it as a standard action without database structure conversion to newer format.
Nwind.mdb
0
 
mahomeCommented:
that should do

alter table order add column visible bit

Open in new window

0
 
MickeysAuthor Commented:
I dont have anything to run that in. Are u able to modify my mdb?
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Note also that "Visible" is used as a Property for many items in Access, and while it's not a Reserved word, you really shouldn't use it as a column name ... instead, use something like "bVisible" or some such construct.

0
 
tbsgadiCommented:
!. You shouldn't call a column Visible as it is a reseved word
2. The database is 97 format ,are you using access 97?
0
 
tbsgadiCommented:
If your not using 97 you should convert it to a later version.
0
 
tbsgadiCommented:
Scott...I stand corrected!
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Gary:

I was surprised to find that "Visible" was NOT a keyword ... I had actually written much the same post as you, then decided to search for this before posting, and was really surprised to find it wasn't a keyword for either Access OR Jet ...
0
 
MickeysAuthor Commented:
Great. Thx.

I am using 2003.

Could I ask you to do one more thing?
Take MY attach file above again and do the samething in Customers table.
Add a collumn called bVisible and make in YES/NO or boolean.
(in this mdb it shoulnd be this column in the table order)

0
 
pcelbaCommented:
Please clarify: You need just "bVisible" column in Customers table and Orders must remain unchanged?
0
 
pcelbaConnect With a Mentor Commented:
So the change (in Customers) is here. Just one question: Is it really impossible to add new column if you display the table in Access 2003? FYI, Access 2007 always displays one more column called "Add new field" when you view the table and you can use this column to add new coulmn to any table.
Nwind.mdb
0
 
MickeysAuthor Commented:
Thx.

All I have found is the designview.....I tried to add the column there but it wont be saved so I have no idea why. Anyway thx for the help.
0
 
pcelbaCommented:
Yes, exactly. The design view does not allow it even in Access 2007. Maybe we should read help :-).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.