Changing table structures in Access

[jeff regoord]

Is it possible to change the table structure in Access once the table
has data in it and how would one attempt this if so?

[John Winterbottom]

"jeff regoord" <jh***@netzero.com> wrote in message
news:da**************************@posting.google.c om...

Is it possible to change the table structure in Access once the table
has data in it and how would one attempt this if so?

yes:-

1. From the UI - table design view
2. Programmatically using DAO or ADOX objects
3. With DDL from the query design window, (sometimes - depends on what you
want to do), or programmatically.with DoCmd.RunSQL, DAO or (better) ADO.

Lookup up ALTER TABLE statement in SQL Reference.

[Don Leverton]

Hi Jeff,

One way is to design (a / several) Select query(ies) that includes the
fields / data that you want, then change (it / them) into a Make Table
Query(ies). When you're satisfied with the way you have them split up,
delete the original table as well as these make-table queries.

--
HTH,
Don
=============================
E-Mail (if you must)
My*****@Telus.net

Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.

Do Until SinksIn = True
File/Save, <slam fingers in desk drawer>
Loop

================================
"jeff regoord" <jh***@netzero.com> wrote in message
news:da**************************@posting.google.c om...

Is it possible to change the table structure in Access once the table
has data in it and how would one attempt this if so?