maximum number of records

[norman]

I'm trying to determine the absolute maximum number of
records allowed by Access 2000. does anyone have this
information at hand.

and is it possible to open (in access) a foxpro (v2.5) dbf
file?

 

[John Vinson]

I'm trying to determine the absolute maximum number of
records allowed by Access 2000. does anyone have this
information at hand.

There is no explicit limit on the number of records. A single database
is limited to 2 GByte. In practice, tens of millions of records can be
handled with careful design of your queries and other objects.

and is it possible to open (in access) a foxpro (v2.5) dbf
file?

Yes - use File... Get External Data... Import (or Link), and select
..dbf from "Files Of Type". There are an assortment of different
flavors of .dbf but you get your choice, and I'm pretty sure that
FoxPro 2.5 is among them.

 

[Jeff Boyce]

Norman

Why? Like, is this a bar bet or something? Can we get a piece?

(it sounds facetious, but it's not -- our answers may change, depending on
what you are trying to accomplish...)

Jeff Boyce
<Access MVP>