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 gkittelson 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. oate3572

    A97 table row number limits?

    Forgot to say that my table currently has 5 columns - 1 autonumber (which I assume is a long), 2 longs and 2 strings (10 and 50 characters). I reckon a total of 92 bytes, which multiplied by my 5 million row estimate gives me a 460 MB table. Am I crazy to be attempting anything this big in...
  2. oate3572

    A97 table row number limits?

    Any thoughts on the upper limits (both theoretical and practical) on the number of rows in an Access 97 database table? I am starting an application where the client has stipulated delivery in Access 97. My current db plan would result in a table with of the order of 5 million records. Trouble...
  3. oate3572

    simulate full outer join

    thanks swampboogie. That's got me out of a tight spot. Being able to use the shorthand method would be nice, but I guess we can't have everything! cheers
  4. oate3572

    simulate full outer join

    sorry - accidental key press. What I meant to say was that I have been led to believe that Access does not support full outer joins. Is this true? If it is true, are there any work arounds? thanks
  5. oate3572

    simulate full outer join

    I have two very simple tables, with a common field on which I need to perform an outer join, so that I can return a combined list of all the records from both tables. I've read somewhere that Access does not support ful

Part and Inventory Search

Back
Top