How to overcome the size limitation of MSAccess

i'm new to database and i heard that MSAccess has maximum storage of 2GB approximately.... what if i started in MSAccess and if the amount exceeds 2GB and still i want to continue my work in that... is there any possibility of doing that ? thanx.....

Jun 27 '07 #1

Subscribe Post Reply

10734

ADezii

8,834

Expert 8TB

i'm new to database and i heard that MSAccess has maximum storage of 2GB approximately.... what if i started in MSAccess and if the amount exceeds 2GB and still i want to continue my work in that... is there any possibility of doing that ? thanx.....

To the best of my knowledge, you cannot exceed the built-in design limitations of Access. If you demand is such, it is time to move up to one of the Big Boys such as Oracle, SQL Server, etc. Please do not double, in your case triple, post. Someone will get to your question within a reasonable time frame. Previous Posts have been deleted.

Jun 27 '07 #2

missinglinq

3,532

Expert 2GB

The first thing you need to understand is that the 2 GB limit allows for a HUGE number of records. The second thing is that if, down the road, you do find you need more "space" you can migrate to something like SQL Server or MySQL and continue to use the Access frontend (forms, etc) that you already have! There is even a built in Wizard for upsizing to SQL Server! Another method of "beating the limit" that I've seen mentioned from time to time is to place your tables in a one or more databases, then linking to these tables. But as I've said, 2 GB allows for a lot of records.

In Access Help simply enter the word "upsize" and explore the related links generated.

BTW, it's really good to see someone doing advance planning like this, rather than simply jumping in feet first and hoping things will work out later!

And please don't post the same question/problem more than once!

Good luck !

Linq

Jun 27 '07 #3

krishnasarma

ok thanks 4 ur reply .. i'l not post same question repeatedly hereafter,
can u explain a bit more abt (placing table in one or more database and link to these tables) and how it'l expand the storage size.. thanx ur reply really help me a lot......

Jun 28 '07 #4

hyperpau

184

Expert 100+

ok thanks 4 ur reply .. i'l not post same question repeatedly hereafter,
can u explain a bit more abt (placing table in one or more database and link to these tables) and how it'l expand the storage size.. thanx ur reply really help me a lot......

create another ms access file and place the other tables there. Then
on the main access file that you're working on, click File -> get external data -> Link tables. Find those other access file where you saved the other tables.

Jun 29 '07 #5

Similar topics

Does PostgreSQL have a size limitation

by: Rick Brough | last post by:

I'm in the early stages of researching the migrating of an OLTP Oracle database (size 200+ GB) and still growing to PostgreSQL 8.x. Before I spend alot of time documenting the migration path, I'd...

PostgreSQL Database

Too Simple Question: Statement Size

by: Anurag | last post by:

This simple one beats me all ends up(sincerely). I have been doing DB2 UDB for some time now, reading a lot of good discussions in this forum, writing some answers, asking a lot more but this...

DB2 Database

Size limitation with MSAccess 2k image control

by: Scott Simonson | last post by:

Sorry if this posts twice. I can only assume that my previous post didn't because I attached a small image to it to show the error. I have had an application in MSAccess 2k for about year now...

Microsoft Access / VBA

the maximum memory size allowed in malloc

by: Jerry | last post by:

I am wondering what is the maximum size of memory that malloc() could handle. Is there any limitation on that? Where am I supposed to get this kind of information? Thank you everybody.

C / C++

Any limitation on View State Size

by: praveen | last post by:

Hello Folks; I am working in ASP.NET application. I would like to know how much characters ( OR How much Size?) I can keep in View State variable. I want the limitation in its size. Is there any...

ASP.NET

maxRequestLength not effective for increasing Upload size limitation

by: Joseph Geretz | last post by:

I'm developing a Web Service using DIME to download and upload files from and to an IIS server. In order to increase the download filesize to unlimited, I have the following block in my App.config...

.NET Framework

Program size limitation

by: AB | last post by:

Hello all, I heard once that there is a limitation on the number of lines of code that a program can have when using C, but not for C++. Is this true? Any ideas?

C / C++

how 2 overcome the size limitation of MSAccess(reply pls..)

by: krishnasarma | last post by:

tell me please.......i'm new to database and i heard that MSAccess has maximum storage of 2GB approximately.... what if i started in MSAccess and if the amount exceeds 2GB and still i want to...

Microsoft Access / VBA

How can I overcome the buffer limitation using StreamReader.ReadTo

by: =?Utf-8?B?UHVjY2E=?= | last post by:

Hi, I'm using VS 2005, ,.net 2 for C# windows application. I'm using Process to run a C application and redirecting its standard output so I can read it with StreamReader.ReadToEnd. It's only...

C# / C Sharp

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice