Editing a MS Access database
-
Hi, I need to modify a MS Access database: - Rename tables - Rename columns - Add new columns and set field properties (Can't seem to set "Allow Zero Length" with Access SQL) I'm finding that SQL for Access is sometimes lacking when I need to update the database as my application grows. I see from my on-line research that some people turn to DAO or ADOX. If I'm working with an Access db, which should I use and why? PS - Why would MS Access have a field property "Allow Zero Length" but no SQL statement to set/change it? thanks, Ron
-
Hi, I need to modify a MS Access database: - Rename tables - Rename columns - Add new columns and set field properties (Can't seem to set "Allow Zero Length" with Access SQL) I'm finding that SQL for Access is sometimes lacking when I need to update the database as my application grows. I see from my on-line research that some people turn to DAO or ADOX. If I'm working with an Access db, which should I use and why? PS - Why would MS Access have a field property "Allow Zero Length" but no SQL statement to set/change it? thanks, Ron
First of all, only Text, Memo and Hyperlink fields can accept zero length strings and therefore have that property. You may want to look into using DDL to manage your table properties. Steve
-
First of all, only Text, Memo and Hyperlink fields can accept zero length strings and therefore have that property. You may want to look into using DDL to manage your table properties. Steve
Thanks Steve, I knew that only Text, Memo and Hyperlink fields only have that property, but as far as my research, I can't use SQL to change this property... if there is, please let me know. Thanks for the tip on DDL, I'll do some research. Ron
-
Thanks Steve, I knew that only Text, Memo and Hyperlink fields only have that property, but as far as my research, I can't use SQL to change this property... if there is, please let me know. Thanks for the tip on DDL, I'll do some research. Ron
I always do such edits in Access. I have never tried to alter table structures dynamically from VB. You may want to try posting your question in MDBMakers.com. This forum has Access MVP's and many knowledgeable users who may be able to help you. Steve