Limitations of Access

[NatronA111]

Hello all...

I'm sure this has been answered before, but I was searching through the threads and can't find an answer...

What are the record limitations of Access?

I want to import 10,000 records at a time into a table and run a query on it that has numerous calculated fields. Think this will be okay?

I just want to make sure that I don't start something I can't finish!

Thanks...
Nate

[missinglinq]

Here's a list of all specs/limits (as published by Micro$oft) from our tutorial section. Don't see anything specifically about limit of records to import. I tend to think this would primarily be a function of available memory.

Microsoft Access Specs

Welcome to TheScripts!

Linq ;0)>

[NatronA111]

Thanks for the help, Linq!

[missinglinq]

That's why we're here!

Linq ;0)>