Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by erkle

  1. erkle

    How do set the default property using SQL?

    In MS Access 2000, what SQL statement would I use to add a field to a table and set the default property. I know that to add a field I could use, "ALTER TABLE Customers ADD Comments Text 100;" but I don't know how to make this field have a default value of "test". Can...
  2. erkle

    Removing a MS Access password using DDL

    I needed to do this because having a password is causing a lot of grief on a production application when we want to make changes. Thanks for you help.
  3. erkle

    Removing a MS Access password using DDL

    Is it possible to remove a MS Access database password using VB code?
  4. erkle

    How do I grant permissions to a table in Microsoft Access using SQL?

    Yes, please send me the ADO code to grant permissions to a table of Access database.
  5. erkle

    How do I grant permissions to a table in Microsoft Access using SQL?

    I know how to grant permissions in the GUI but I need t be able to do this through code. Can anyone help?
See more

Part and Inventory Search

Back
Top