MS Access 2007 Specifications...

[Back Access]

Hello NewsGroup,

Are there any specification documents, web pages, that describe Access 2007
characteristics completely? I found on the MS website very good field
specification, I want to know things like; Max. Database size, Number of
objects per database, Number of fields per table now that an Excel sheet can
have ~16, 000 columns and one imports an Excel sheet into a table, number of
constraints per table, number of nested levels in a SAL
statement,..............., etc.

Many thanks Newsgroup.

Regards,
Back Access

 

[Brendan Reynolds]

I don't think there have been any changes in these areas. The new Access
database engine is based on the JET database engine. It has some new
features, such as support for 'complex data', but to the best of my
knowledge all of the specifications such as database size, number of
objects, number of columns etc. remain as in JET 4.

 

[Back Access]

Thank you very much Brendan. Not that there is anything wrong with the
current JET 40 database structure. Just asking how much further MS tool
Access as Excel seems miles a head of where it with 2003 down to 97.

Thanks again, take care.

Regards,
Back Access.

 

[Brendan Reynolds]

BTW: Here's a link to the online help topic on Access 2007 specifications
....

http://office.microsoft.com/client/...rt=2&ns=MSACCESS&lcid=2057&pid=CH100621861033

If you already have Access 2007, you can get to this topic within the help
window by searching for the topic ID HA10030739.

 

[Back Access]

Hey thanks Brendan, just the page I've been looking for. Go well.

Regards,
Back Access