work around max records

  • Thread starter Thread starter Cricri
  • Start date Start date
C

Cricri

Hi,

I was wondering if there was a work around the 4000 records limitation in
access. I am creating magnetic susceptibily charts for drillhole and so far
I have a few hole with more than 4000 records (max is 11977 records).

My chart works but it just shows the first 4000 records for the hole.

Is there a way to embed an excel spreadsheet in access or just link it?

Cheers
 
What 4000 record limitation in Access? I have tables with 100,000 + rows
and I've heard of million-row tables.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi,

I was wondering if there was a work around the 4000 records limitation in
access.
Click to expand...

There is no such limit in Access tables.
I am creating magnetic susceptibily charts for drillhole and so far
I have a few hole with more than 4000 records (max is 11977 records).

My chart works but it just shows the first 4000 records for the hole.
Click to expand...

My guess is that it's a limit in Windows Graph, the utility that generates the
charts.
Is there a way to embed an excel spreadsheet in access or just link it?
Click to expand...

You can link Excel charts to Access tables, or Access frontends to Excel
spreadsheets. I'd suggest storing the data in Access and using Excel to
generate the charts, it's got a lot more graphics tools.
 
Back
Top