• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

1. Core Access > 9. Work with Any Amount of Data

Work with Any Amount of Data

Plan a multiple-database architecture to house any amount of data—gigabytes, even terabytes!

The only size limit in Access is that a table can’t contain more than 1GB of data. Well, if that’s it, there is a lot of opportunity here. Access isn’t cut out for incredibly large stores of data, granted, but that’s not the point. If SQL Server or Oracle isn’t going to be installed at your place of business for another year, take advantage of Access’s flexible architecture to work with any amount of data.

The technique is simply to make a plan for how to structure the data among multiple database files and tables. There is no rule that says an Access application must reside completely in a single Access file. An Access application can be split into a front end and a back end. That is, the forms, reports, and queries stay in the front end, and the data itself is put into a separate file. The data tables are then linked to the front end. This is standard fare, the quintessential client/server in its simplest execution, shown here in Figure 1-19.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint