Results 1 to 2 of 2

Thread: (SQL) create table statement

  1. Jul 26th, 2001, 06:55 AM #1
    reznor
    reznor is offline

    Thread Starter
    Addicted Member reznor's Avatar
    Join Date
    May 2001
    Location
    Netherlands
    Posts
    151

    (SQL) create table statement

    I know now to use the sql create table statement, but I use it on Access. The default property for the fields is not to allow null values. Is it possible to set the property Allow Zero Lenght to true in Access from VB?

    Is there any other way (ADO?) to create tables in an Access database?

    Rick
    "Computers are incredibly fast, accurate and stupid. Human beings are incredibly slow, inaccurate and brilliant. Together they are powerful beyond imagination." - Albert Einstein
    Reply With Quote Reply With Quote
  2. Jul 26th, 2001, 09:34 AM #2
    PsudoLogical
    PsudoLogical is offline
    Addicted Member PsudoLogical's Avatar
    Join Date
    Dec 2000
    Location
    Upstate N.Y.
    Posts
    144
    It is very possible to manipulate almost any aspect of an Access Database with Ado. You must use the ADOX API. For information on capabilities and use of the API, I suggest you either go to the msdn developer library, or look for a book on database programming for visual basic

    Cheers
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width