Lines of data

I have a user who needs to put up to 25,000 lines of data in a table a year. We will be generating weekly and montly reports from this database. They have access to excel. What's the best way to deal with this size issue. I'm afraid of loading down the database and making it too big to run the reports.

Hi,

Keep in mind that a Microsoft Access database file size limit is 2 gigs
minus the system tables (Msys*).

You can try calculating the estimated size of your file. Example:

Field Name Data Type Field Size # of bytes
Field1 Text 50 50
Field2 Decimal 12
Field3 Integer 2
Field4 Long Integer 4
Field5 Single 4
Field6 Double 8

Total # of bytes per Record 80
x
Expected # of Records 25,000

Total est. file size 2,000,000 bytes

NOTE: see the Microsoft Access help topic "FieldSize Property"

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
http://www.microsoft.com/security/security_bulletins/ms03-026.asp and/or
to visit Windows Update at http://windowsupdate.microsoft.com/ to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights




--------------------
| Thread-Topic: Lines of data
| thread-index: AcQ3ZUlXbjSrtZqjRhmSBY8QUuSPNA==
| X-WN-Post: microsoft.public.access.tablesdbdesign
| From: "=?Utf-8?B?TGlzYQ==?="
| Subject: Lines of data
| Date: Tue, 11 May 2004 07:36:03 -0700
| Lines: 1
| Message-ID:
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.tablesdbdesign:79202
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| I have a user who needs to put up to 25,000 lines of data in a table a
year. We will be generating weekly and montly reports from this database.
They have access to excel. What's the best way to deal with this size
issue. I'm afraid of loading down the database and making it too big to
run the reports.
|