La Vie En Rose for 2005 January 26 (entry 0)

(7) Wed Jan 26 2005 11:34 PST Ohhh...Access: I really need someone who knows Access to help me out. I need to add fields in the form of an already exsisting database. I really hope that's even possible--there's like, 400 entries, and I *don't* want to have to start over. It occurs to me there might be a reason no one uses Access.

Comments:

Posted by Brendan at Wed Jan 26 2005 20:47

I use Access, but there is a reason nobody uses it (which is that it doesn't fully support standard SQL, and it's terrible).

That said, I think what you're asking is how to add a new column to an existing table. To do that, find the table (after clicking the Tables button under Objects in your database window), right-click on it, and click Design View on the context menu. There should be a list of Field Names, Datatypes, and Descriptions. Just find the first empty cell below the existing ones, give it a name and choose a datatype. If you need to make it more specific, you can use the General tab at the bottom of that window.

Posted by Bill Gates at Wed Jan 26 2005 21:03

Access is user-friendly and the standard for small business/projects in today's fast paced business world.

Of course you can add a column to an existing table. Brendan's explanation should suffice. You think Access is hard, try using ColdFusion or Peachtree databases. Not fun. Send me money!

Posted by Susie at Wed Jan 26 2005 21:49

Dear Bill,
Access is stupid and impossible to figure out. Dream on.

Susie

No Check Enclosed.

Posted by Rachel at Wed Jan 26 2005 22:09

Well, fabulous, I got it all fixed in the table, but can't save the table as the same name as before, since it's read-only, and none of the changes are refelected in the form. Grrrrrrr...

Posted by Brendan at Thu Jan 27 2005 15:50

Can you check the properties of the table and make it not read-only, then do the change? (I'm not currently on a computer with Access, so I can't tell you for sure.)

Posted by Rachel at Thu Jan 27 2005 18:55

I think it will help once we get our new computer and upgrade to Office Professional 2003. Right now we are using version 5000 B.C.

Posted by Susie at Thu Jan 27 2005 20:10

5000 BC, hehehe