Access - Windows 98 - Limited to 65535 entries ?

jmarc

Is that right.. under Win 98..

The quantity of records in a table
is limited to 65535..?

Argument is a 'long' was supported
by only 32 bits under Win 98...!

Who may talk a bit more about this..

jmarc

Nov 3 '06 #1

Subscribe Reply

2097

Smartin

jmarc wrote:

Is that right.. under Win 98..

The quantity of records in a table
is limited to 65535..?

Argument is a 'long' was supported
by only 32 bits under Win 98...!

Who may talk a bit more about this..

jmarc

I dunno... I just inserted over 100,000 rows of type long into an A97
table on a W98 box. Seems to work just fine.

Are you sure you're not hitting an Integer (16 bit) limit of some kind?

--
Smartin

Nov 4 '06 #2

Albert D. Kallal

There is not a real limitation on number of records in a table in ms-access.

A long integer is used, so, that would suggest a max number of records about
2 billion....

The number of records you can place into a table is actually limited by the
SIZE OF EACH record. You have a 1 gig MAX file size, and thus the number of
records you can place in the table will vary, based on how large each record
is...

For a97, max size is 1 gig

The size limit of access 2000 and beyond is 2 gigs.

So, if you take a average name in a mailing list, add a few extra
fields...your record size might be about 120 characters on average in size.

So, the number of records you can store is:

2 gig = 2,147,483,648 Bytes
1 Character = 1 Byte
120 Characters = 120 Bytes

2 gig / 120 = 32 million records

So, the limit is NOT the number of records..but "how many" records you can
fit into 2 gig.

Of course, if each customer name only takes up 60 characters...th en you can
store 64 million records in the file. (or 32 million in a97)

So, a file with 100,000 records in ms-access is not large at all, and can
usually be processed in a few seconds at most...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.attcanada.net/~kallal.msn

Nov 4 '06 #3

Karl

That is the row limit in Excel.

"jmarc" <jm***@incursio n-voyages.comwrot e in message
news:VEO2h.4035 4$P7.33799@edtn ps89...
Is that right.. under Win 98..

The quantity of records in a table
is limited to 65535..?

Argument is a 'long' was supported
by only 32 bits under Win 98...!

Who may talk a bit more about this..

jmarc

Nov 4 '06 #4

jmarc

Thank you All,

I got my answer. And I am pleased
to know few things more about access.
But the access Help give a lot of information,
but nothing about number of records.

Probably it was the Excel limitation I
heard a long time ago, and just thought
it was about access. Karl is right about
Excel..

Thanks again..!

jmarc...
"jmarc" <jm***@incursio n-voyages.comwrot e in message news:VEO2h.4035 4$P7.33799@edtn ps89...
Is that right.. under Win 98..

The quantity of records in a table
is limited to 65535..?

Argument is a 'long' was supported
by only 32 bits under Win 98...!

Who may talk a bit more about this..

jmarc

Nov 6 '06 #5

Similar topics

2948

General question on charging for data access

by: Frnak McKenney | last post by:

Back when computer dinosaurs roamed the earth and the precursors to today's Internet were tiny flocks of TDMs living symbiotically with the silicon giants, tracking access to data processing resources was much simpler: you logged in with a userID and password, and when you were done you ended your session by logging out (or occasionally by being disconnected). Connection time was easy to measure, and it made sense to both the customer...

PHP

12348

Limit of users in Ms-Access?

by: Hannu | last post by:

Hi. In the ldb file you can see the users of the mdb-file. If you open the mdb-file your machine and username will be written in the lbd- file. Allthough you close the mdb-file your name won't disappear from the ldb-file, before every user has closed the mdb-file. I have heard that there will be problems if the amount of users will be over 10 in mdb-files. Is that true? Hannu

Microsoft Access / VBA

8850

How do I create pdf reports from Access?

by: dog | last post by:

I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a

Microsoft Access / VBA

6584

Access expoert reports to PDF using PDF writer 6.0 issues

by: Grasshopper | last post by:

Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am not logged into the server, Access is not able to print to the printer. The error is pretty...

Microsoft Access / VBA

2770

What techniques are key to Access performance with separate front-endand back-end Access implementation via a LAN?

by: Bob Alston | last post by:

Most of my Access database implementations have been fairly small in terms of data volume and number of concurrent users. So far I haven't had performance issues to worry about. <knock on wood> But I am curious about what techniques those of you who have done higher volume access implementations use to ensure high performance of the database in a multi-user 100mbps LAN implementation??? Thanks

Microsoft Access / VBA

10803

HKEY_LOCAL_MACHINE Registry Access

by: Kevin Swanson | last post by:

I'm attempting some remote registry manipulation via C#. I've written a test app to simply grab a specified key from a specified hive on a specified machine. The call to OpenSubKey is throwing System.SecurityException. Also of note: Sitting at my local box, I can open regedit and connect to the remote registry. I see three hives: _CLASSES_ROOT, _LOCAL_MACHINE, and _USERS. I can open all but HKEY_LOCAL_MACHINE. When I try to expand that...

C# / C Sharp

11076

Access Table to text file (CSV, Tab, etc). Is there an easy way to do this?

by: Irene | last post by:

Hi, I have an MS Access Database with 1 Table containing about 2 million records in Unicode (diferent languages). I would like to export the Table to a Text file (CSV, Tab, etc.) Access dows only export about 65,000 at 1 time. Almost an imposible job.

Microsoft Access / VBA

9205

Windows Autorun FAQs: Description

by: AmberJain | last post by:

Windows Autorun FAQs: Description NOTE- If you are unfamiliar with the concept of autoruns, then read "Windows Autorun FAQs: Overview". Que-1: How can I safely remove or edit the autorun settings on my PC? Ans: I recommend that you backup all of your important data before trying anything mentioned in this article. When a person is tweaking with autoruns, one has to rely on 'trial and error' methods and so there is always the possibility...

Microsoft Windows

8324

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

8842

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++

8740

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8513

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

8617

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7352

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

5642

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

4330

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1733

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General