473,325 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Record Limitation in Access 2003

1
Hi, I am new to Access 2003 on XP. I am creating a database from a current report that has exceeded Excel 2003's row limitation. My concern is running into an Access limitation after creating the database. I have read the post entitled "How to overcome the size limitation of MSAccess" and it was very helpful. However, is there a definitive answer as to how many records a 2GB database can hold? or is it dependent upon the record size (2 fields vs. 20 fields)? The idea of creating multiple databases and then linking the tables is also a viable option for me. Has anyone run any to problems with this solution I should know about before I begin? All help/advice is GREATLY appreciated!
Jul 11 '07 #1
2 2957
kepston
97 Expert
The maximum number of records is defined by the size and number of fields.
I have successfully linked several databases in the past, but never to the size you are describing.
I only hit the 2GB limit once, and that was because I was inserting pictures, which Access converted to bitmaps.
A database that is very active, lots of records adding and deleting, will also grow quickly. Regular compacting is often necessary.
Jul 19 '07 #2
vkong85
24
There are two things that you can do. As said before be sure that you are regularly compacting and reparing your database through "tools> database utlities> compact and repair database" this usually takes care of most problems. Another solution is to basically split your database in two. So that data is linked from two databases both which contain half of the information. this way you can get two 1 gig databases instead of one full 2 gig database. To do this you would simply open a blank database and import the tables you need. then go back to the main database (where entry of records occurs) and then just link the tables.
Jul 19 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: mark | last post by:
Access2000 How do I write a query that combines the CTC field from each record below into one record? I need to concatenate the CTC field with a separator, like below: ...
4
by: Joe User | last post by:
Hi all....I have a feeling this is going to be one of those twisted query questions, but here it goes anyways.... I want to generate a report that shows the chronology of events (represented by...
0
by: Dave | last post by:
I am trying to develop Data Access Pages (DAP) within Access 2003, specifically using Pivot Table Lists. When creating pivot tables as forms, all of my records in a table consisting of over 18,000...
5
by: Ross A. Finlayson | last post by:
Hi, I'm scratching together an Access database. The development box is Office 95, the deployment box Office 2003. So anyways I am griping about forms and global variables. Say for example...
1
by: Matt | last post by:
Has anyone had any experience with running into a 22.75" page width limitation with Access reports? I am trying to print a report to a large format printer that is under (including margin) the...
1
by: welime | last post by:
Hi there, am having a problem when trying to display my reports. The error am getting when displaying is out of range. I wanted to know if access has limitation when it comes to displaying records....
16
by: google | last post by:
In a continuous form the following code is under a button in the form header. In Access 2003 and earlier, this goes to a new record, then adds relevant data to that new record. DoCmd.GoToRecord...
6
by: jsacrey | last post by:
Hello everybody, I've got a bit of a situation that I could use some guidance with if possible. I work for an auditing firm where my users audit electronic shipping data for customers to see if...
1
by: shayvillere | last post by:
I have a corrupt record that disappears after a compact, but reappears several days later. This is on a widely distributed Access 2003 application that is used by about 100 users. The database...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.