Search:

Type: Posts; User: aussiemcgr

Search: Search took 0.08 seconds.

  1. Replies
    12
    Views
    5,186

    Re: Connecting to Access 2007 Database

    Well the database is designed where we have 16 different categories of data for 285 things. Each category of data holds monthly data for each thing, going back to January 2005.

    So we have it...
  2. Replies
    12
    Views
    5,186

    Re: Connecting to Access 2007 Database

    The Total row is actually not calculated from the other rows. It is data configured from the rows and other things that we retrieve when we do a data pull for the rest of the rows. For that reason,...
  3. Replies
    12
    Views
    5,186

    Re: Connecting to Access 2007 Database

    The Total row is actually not calculated from the other rows. It is data configured from the rows and other things that we retrieve when we do a data pull for the rest of the rows. For that reason,...
  4. Replies
    12
    Views
    5,186

    Re: Connecting to Access 2007 Database

    When using the ORDER BY query, is there a way to single out one specific value and make it last? I ask because I have 200 or so rows of data, each with a unique name, and then at the end a row named...
  5. Replies
    12
    Views
    5,186

    Re: Connecting to Access 2007 Database

    Ok, here are 2 Database questions again.

    How do I add columns to my database tables?

    Also, on that note, I understand how to insert new rows, but how do I insert new rows in alphabetical order...
  6. Replies
    12
    Views
    5,186

    Re: Connecting to Access 2007 Database

    Ah, worked like a charm. Cheers mate.

    I imagine I will run into more problems along the way and I'll post questions as they occur.
  7. Replies
    12
    Views
    5,186

    Re: Connecting to Access 2007 Database

    Ok, so I have gone leaps and bounds with this. My problem wasn't with JAVA but with drivers and all that other stupid crap.

    Now I have a query question that may be easier to answer.

    I have...
  8. Replies
    12
    Views
    5,186

    Connecting to Access 2007 Database

    Can anyone give me some sample code and explanation for how to correctly make a connection, read data, and write data to an Access 2007 Database (.accdb). I have been searching the internet all...
Results 1 to 8 of 8