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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: erkle
  • Order by date
  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?

Part and Inventory Search

Back
Top