How to make indexed or linked table

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • prasad joshi
    New Member
    • Aug 2012
    • 30
    #1

    How to make indexed or linked table

    Hello

    I am developing a access application.

    The problem is in every month I get 8 gb of data .

    I want to make a access application such that it should store 8 gb of data in every month.

    Please help me

    How to design such application???

    can access 2007 will hold 8gb of data in every month?

    how to resolve this problem

    I am new to access ,Please help me..

    thanks
    Tags: None
    • Stewart Ross
      Recognized Expert Moderator Specialist
      • Feb 2008
      • 2545
      #2
      Access has an absolute limit on the size of any database of 2GB. It is NOT the correct product to use if you want to deal with 8GB of data per month.

      It is not possible to give detailed advice on what to investigate, as you have told us nothing at all about your application and the 8GB of data it is said to require storage for. SQL Server, Oracle, DB2 and so on would be potential choices, but whatever you settle on the server must have suitable disk space and throughput available as you apparently need to store around 100GB of data per year.

      -Stewart

        Comment

        Previous template Next
        Working...