Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Modifying the database with sql statements

Discussion in 'Information Technology' started by Brandon Owensby, Nov 3, 2005.

  1. Brandon Owensby

    Brandon Owensby
    Expand Collapse
    Guest

    Is there away to create querys, indexes, or primary keys using sql
    statements in access? I'm using a Microsoft.Jet.OLEDB.4.0 connection from
    a csharp program to access Access. I'm trying to copy data to another
    location with this program but I need to create one of the above to make it
    more efficient. I'm not wanting to manually do it because we will be
    downloading a new version of the databae periodically and having to run this
    program again and again and I don't want anyone to have to manually edit the
    database everytime we download a new version.

    Does anyone have any thoughts?

    Thanks,
    Brandon
     
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Yes, you can use standard DDL.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Brandon Owensby" <123@abc.com> wrote in message
    news:O6xeM%2393FHA.3880@TK2MSFTNGP12.phx.gbl...
    > Is there away to create querys, indexes, or primary keys using sql
    > statements in access? I'm using a Microsoft.Jet.OLEDB.4.0 connection

    from
    > a csharp program to access Access. I'm trying to copy data to another
    > location with this program but I need to create one of the above to make

    it
    > more efficient. I'm not wanting to manually do it because we will be
    > downloading a new version of the databae periodically and having to run

    this
    > program again and again and I don't want anyone to have to manually edit

    the
    > database everytime we download a new version.
    >
    > Does anyone have any thoughts?
    >
    > Thanks,
    > Brandon
    >
    >
     
  4. Ron Hinds

    Ron Hinds
    Expand Collapse
    Guest

    "Brandon Owensby" <123@abc.com> wrote in message
    news:O6xeM%2393FHA.3880@TK2MSFTNGP12.phx.gbl...
    > Is there away to create querys, indexes, or primary keys using sql
    > statements in access? I'm using a Microsoft.Jet.OLEDB.4.0 connection

    from
    > a csharp program to access Access. I'm trying to copy data to another
    > location with this program but I need to create one of the above to make

    it
    > more efficient. I'm not wanting to manually do it because we will be
    > downloading a new version of the databae periodically and having to run

    this
    > program again and again and I don't want anyone to have to manually edit

    the
    > database everytime we download a new version.
    >
    > Does anyone have any thoughts?
    >
    > Thanks,
    > Brandon


    Search Access Help for "CREATE INDEX", "CREATE TABLE"
     

Share This Page