Adding Tables and Fields to an existing database 
Author Message
 Adding Tables and Fields to an existing database

My employer is always asking me to add a field here or a field there.  Now
the way I've been doing these additions is by having a function like, for
example 'AddEmail' to add an email field.  The function would try to add
the field, if it exists and error is created so the funtion quits.  So if
it does't generate an error, the field is not there and it goes ahead and
creates it.  This is all done at the programs startup, or when restoring a
back-up.

Since he's been asking almost every week to add fields, I'll amassed a
horrible collection of these little functions. It looks messy and confusing
to read.

Is there an easier way to add fields to a database...at startup.  The same
way from tables.

Also, a text field's character size cannot be changed at runtime, can it?
If it can, how?

Thanks....alot!

Jeff



Sun, 14 Nov 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How to modified existing field and add new field in existing table for Access database

2. Create new field in existing table exactly like field in second table

3. Adding required fields with default values to existing tables

4. Adding new fields to an existing table

5. Adding fields to existing ADO tables

6. Add New Field in existing Table (VB6)

7. Adding required fields with default values to existing tables

8. Adding / Appending fields to existing table

9. Adding a new field to an existing table via ADOX

10. adding a autonumber field to an existing database

11. Adding a new field to an existing database

12. Add table to existing Database..

 

 
Powered by phpBB® Forum Software