2 GB size limit fix - Microsoft Access / VBA

Bob

Hi all,

My databases seem to become corrupted as soon as they reach 2GB. Once
it does become corrupted the only fix is to create a new database and
transfer everything into that. I need to avoid that happening and I'm
not sure exactly how to do that. Is there a way that I can check the
size of the database (don't know how) and then remove obselete tables
(know how to) if its over a threshold and then compact and repair the
db (know how to)? Or is there a better way to get around or prevent
it?

Cheers,

Bob

May 18 '07 #1

Subscribe Reply

51584

'69 Camaro

Hi, Bob.

My databases seem to become corrupted as soon as they reach 2GB.

Are you compacting the database files regularly? If they're compacted and
they're still close to 2 GB, you should migrate the data to a larger
capacity database. A stop-gap maneuver would be to move some of the tables
to another MDB file, so as to split up the data into two files that each
have a maximum size of 2 GB. The downside to this is that only tables in
the same file can have referential integrity enforced.

Is there a way that I can check the
size of the database (don't know how)

Yes. It can be checked whenever the database file is opened to determine if
the file surpasses a certain size, and if it is, compact it. If it's still
above a certain size, the VBA procedure can display a message to the user
that the file is near maximum capacity and the user needs to do something
about it. For an example of how to check the file size and automatically
compact the database, please see the tip, "How to compact the current
database automatically when it reaches a certain size," on the following Web
page:

http://www.access.qbuilt.com/html/vba1.htm

Or is there a better way to get around or prevent
it?

Consider migrating the data to a client/server database engine. There are
several free ones from the major database vendors, such as Oracle 10g
Express and SQL Server 2005 Express, which will hold up to 4 GB of data.
Other free ones hold even more. Please see the following Web page for links
to these database engine descriptions to compare their major features and
additional links to each vendor's download page:

http://www.backends.qbuilt.com/

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

May 18 '07 #2

Tom van Stiphout

On 17 May 2007 19:12:05 -0700, Bob
<sc*******@colo nialfirststate. com.auwrote:

Obsolete tables can be removed at any time; you don't have to wait
until your file size is too high.
You can test the size of a file many different ways. Have you tried
the built-in FileLen function?

If you regularly get up to that limit, and have an otherwise good
database design, it may be a good time to invest in SQL Server or
another database with much larger capacity.

-Tom.

>Hi all,

My databases seem to become corrupted as soon as they reach 2GB. Once
it does become corrupted the only fix is to create a new database and
transfer everything into that. I need to avoid that happening and I'm
not sure exactly how to do that. Is there a way that I can check the
size of the database (don't know how) and then remove obselete tables
(know how to) if its over a threshold and then compact and repair the
db (know how to)? Or is there a better way to get around or prevent
it?

Cheers,

Bob

May 18 '07 #3

Similar topics

7265

Size limit for submit using post ?

by: Gerard Cany | last post by:

I have a problem with a javascript that seems related to the number/size of parameters sent by the form The method for the form is POST (not GET, I know the size limit with GET) The symptom : some times, I receive a javascript error "Invalid syntax on line xxx", this line contains the call to submit as shown in the following lines : <input type="button" value="<%=Session("Bouton_EnregistrerFicheInclusion")%>"

Javascript

6047

202 File size limit exceeded

by: steve | last post by:

I am setting up a huge database in mysql, and I get the above error in Linux. I believe it is related to the size of one of my tables, which is 4,294,966,772 bytes in size. Can someone help. How can I break that barrier. A google search did not turn up anything useful. -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conformance to usenet standards

MySQL Database

5111

transient cookie size limit

by: Ana | last post by:

I have written some code using transient cookies to send an edited essay from one html page to another. Each paragraph of the essay is saved in separate cookie. If the essay is 4 paragraphs long then I write 4 different cookies. This works on a Macantosh in Internet Explorer but for some reason on a PC the cookies turn up empty. If I make the essay shorter then it works on a PC, so it looks as if I am running up against the size...

Javascript

5024

textbox size limit with sql

by: SpreadPeace | last post by:

I'm hitting the 255 character limit of a text box on a form and was wondering if anyone know how to get around this. Here the scenario.... - Access 2000 front end with Sql Server backend. - The textbound is bound to a field which is nvarchar*4000 (I know with an Access DB you have to use a memo field to get around the size limit, I would think nvarchar*4000 would be good enough) - The 255 character limit only occurs in the VBA code. ...

Microsoft Access / VBA

18760

file size limit exceeded

by: Peter Ballard | last post by:

Hi all, I've got a C program which outputs all its data using a statement of the form: putchar(ch, outfile); This has worked fine for years until it had to output more than 2GB of data today, and I got a "file size limit exceeded" error.

C / C++

31901

TcpClient buffer size limit?

by: Sharon | last post by:

I'm using TcpClient and getting the Stream by: TcpClient tcpclnt = new TcpClient(); . . . Stream stm = tcpclnt.GetStream(); Now, when I'm trying to send a big buffer via stm.Write(...) I get an exception saying that the buffer is too big. I tried to set the tcpclnt.ReceiveBufferSize to the size of the buffer I"m trying to send, but the exception is still thrown, there is no transmit

C# / C Sharp

13072

xmlhttprequest to get dynamically generated data seems to have a size limit

by: ted benedict | last post by:

hi everybody, i hope this is the right place to discuss this weird behaviour. i am getting dynamically generated text or xml from the server side using xmlhttprequest. if the server side data is STATIC, i can have whatever size of data i want. but if the data (xml or text) is generated dynamically using php, then there seems to be a size limit! xmlhttprequest's responseText is truncated, and the xml therefore not well fromed. in border...

Javascript

5441

c# string size limit? length of string limit?

by: Daniel | last post by:

c# string size limit? length of string limit?

C# / C Sharp

2366

how increase the size limit in IE bookmarklets(favlets)

by: HopfZ | last post by:

Internet Explorer 6 bookmarklets(favlets) has size limit. And its size limit depend on the kind of code. For example, CODE A and CODE B (below) are both at their size limit. CODE A does not work (as a bookmarklet), but if you replace the number 44444 at the end to 4444, then it works. CODE B is much longer than CODE A, but if you replace OO in the regular expression to O, then it works. I don't know why they have different size limits....

Javascript

11380

File Size Limit Exceeded - How to handle work around this?

by: eastcoastguyz | last post by:

I wrote a simple program to continue to create a very large file (on purpose), and even though there is plenty of disk space on that device the program aborted with the error message "File Size Limit Exceeded". The file size was 2147483647. I checked ulimit -a and its set to unlimited. Is this a compiler issue? I would like to see a C code example of how to increase the limit or make it unlimited (if that is a wise thing to do).

C / C++

9663

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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9511

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10404

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10136

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9016

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7525

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6765

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4090

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3695

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP