Data structure differences

[Noob]

Anywhere I can find a listing of differences/comparisons between the various access versions and the way they handle data? Anything that details limitations such as A97's 1GB limit or details on different JET versions and if certain versions of access require certain version of JET. Or for that matter any general connectivity issues/differences between versions would be much appreciated

 

[Allen Browne]

The biggest change was A97 => A2000. See:
ACC2000: New Features in Microsoft Access 2000
at:
http://support.microsoft.com/?id=208773

A97 must use Jet 3.5x, and A2000 and later must use Jet 4. See:
ACC2000: New Features in Microsoft Jet 4.0
at:
http://support.microsoft.com/?id=275561

For information on the new bugs since A97, see:
http://members.iinet.net.au/~allenbrowne/tips.html#flaws

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Anywhere I can find a listing of differences/comparisons between the

various access versions and the way they handle data? Anything that details
limitations such as A97's 1GB limit or details on different JET versions and
if certain versions of access require certain version of JET. Or for that
matter any general connectivity issues/differences between versions would be
much appreciated.

 

[Noob]

Many thanks Allen, looks like those will help me more than anything I've found so far.