Computing.Net > Forums > Windows 95/98 > Access97 Record Limitations

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access97 Record Limitations

Reply to Message Icon

Name: Andrew Platt
Date: July 6, 1999 at 14:07:25 Pacific
Comment:

Does any one know of any record limitations in Access 97? I heard that there was a 16000 record limitation, but is that true?
Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: Ben
Date: July 6, 1999 at 14:30:08 Pacific
Reply:

Hi Andrew,

You may know more than I about the subject, but if I understand your question correctly, it is not a restriction on the number of records, but on space. Access 97 is limited to 1 GB, which is quite a lot of information.
I don't remember there being a limitation on the number of records. Hope this was helpful.

Ben


0

Response Number 2
Name: Steven Gotschall
Date: July 7, 1999 at 05:53:48 Pacific
Reply:

Open Access and go to help and search for specifications. You will find all the Access limitations there.


0

Response Number 3
Name: Thibault
Date: July 17, 2000 at 01:47:54 Pacific
Reply:

To my knowledge, Access97 is effectively limited to a Gigabytes of datas but Queries with Transactions are limited up to 195 000 records affected. So if yu use Transactions, be sure to be under this limit !


0

Response Number 4
Name: Sachin Deodhar
Date: August 30, 2000 at 04:17:28 Pacific
Reply:

Just now i tried & i was able to populate 3,50,000 records of 150 char record size. After that size of the database was around 50 MB.
I tried to run a query as well for 3,00,000 records & it works prefectly. It takes around 90 seconds to perform.


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Windows 95/98 Forum Home


Sponsored links

Ads by Google


Results for: Access97 Record Limitations

60 second sound recorder limit www.computing.net/answers/windows-95/60-second-sound-recorder-limit/23718.html

Video Editing software/hardware www.computing.net/answers/windows-95/video-editing-softwarehardware/158132.html

Win Sound Recorder without time limit www.computing.net/answers/windows-95/win-sound-recorder-without-time-limit/59593.html