Using SQLite and Python to Solve the Microsoft Access 2 Gig File Limit: Updated: August 08, 2020

by John Lee

Aug 08, 2020 1) Enhanced discussion of Python IDE 2) Python code to show tables and indexes of a Sqlite database The URL said the following about Microsoft Access Access is a great database management solution for small businesses because it makes collecting and storing data accessible on the desktop—without requiring support from an IT administrator The biggest and main problem using Microsoft Access is the 2-gigabyte file limit. A good solution to this problem is to use SQLite. Like Microsoft Access, SQLite is a single file-based database system. The URL indicated that the file size limit of SQLite is140 terabytes. The URL indicates that there are billions of implementations of SQLite. This URL indicates that SQLite is used in the following places, • Every Android device • Every iPhone and iOS device • Every Mac • Every Windows10 machine • Every Firefox, Chrome, and Safari web browser • Every instance of Skype • Every instance of iTunes • Every Dropbox client • Every TurboTax and QuickBooks • PHP and Python • Most television sets and set-top cable boxes • Most automotive multimedia systems

25 pages, Kindle Edition

Published July 30, 2020

About the author

Librarian Note: There are multiple authors in the Goodreads database with this name.

John Lee*, Mystery & Thrillers, Journalist
John Lee, 1850-1922
John Lee, Fiction, wrote "Unicorn Saga"
John Lee, b.1946, History
John Lee, British actor, voice actor, professional narrator, and playwright
John Lee, Allergist
John Lee, Travel writer
John Lee, "the Wealth Dragon", Entrepreneur and property investor
John Lee, Gay Love & Erotica
John Lee*, Fantasy
John Lee*, author and illustrator, "Joy Sun Bear"
John Lee, 1779-1859
John Lee, "the Dealionaire", real estate investor
John Lee, Baron, British MP
John Lee, wrote "MonsterFungus" series
John Lee, petroleum engineering
John Lee, English, early modern studies
John Lee, economics, South East Asia

An asterisk (*) indicates that this is a Goodreads Author