Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

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
0
Mickeys
Asked:
Mickeys
  • 4
  • 3
  • 3
  • +2
2 Solutions
 
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 
pcelbaCommented:
The new column is there. Access 2007 allowed it as a standard action without database structure conversion to newer format.
Nwind.mdb
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
 
pcelbaCommented:
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

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 4
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now