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 MikeeOK 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: *

  1. tatin02

    How to change a field to allow null using jet sql?

    cmmrfrds: I tried your suggestion to use "Jet OLEDB:Engine Type=5" for ADOX, but still got the same "Multi-step OLE DB operation generated errors".
  2. tatin02

    How to change a field to allow null using jet sql?

    cmmrfrds: Yes, I have to do this in code.
  3. tatin02

    How to change a field to allow null using jet sql?

    Thanks for the help from everyone. I have to do it by jet sql since changing the ADOX property doesn't work: it gives a "Multi-step OLE DB operation error". PHV's solution is OK. But I would like to reduce the work as much as possible while keeping everything else unchanged, e.g., the order of...
  4. tatin02

    How to change a field to allow null using jet sql?

    Hi Everyone, I have a table called table1 and two text fields col1, col2. col1's nullable property is true, and col2's is false. I have succeeded in using jet sql: ALTER TABLE table1 ALTER COLUMN col1 text(50) NOT NULL to change col1's nullable property from true to false. However, when I...

Part and Inventory Search

Back
Top