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?
has data in it and how would one attempt this if so?
-
-
Re: Changing table structures in Access
"jeff regoord" <jhr71@netzero. com> wrote in message
news:da91d966.0 407031103.17ca6 baa@posting.goo gle.com...[color=blue]
> 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?[/color]
yes:-
1. From the UI - table design view
2. Programmaticall y using DAO or ADOX objects
3. With DDL from the query design window, (sometimes - depends on what you
want to do), or programmaticall y.with DoCmd.RunSQL, DAO or (better) ADO.
Lookup up ALTER TABLE statement in SQL Reference.
-
Re: Changing table structures in Access
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.Name@Telus.n et
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" <jhr71@netzero. com> wrote in message
news:da91d966.0 407031103.17ca6 baa@posting.goo gle.com...[color=blue]
> 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?[/color]
Comment
Comment