Link to home
Start Free TrialLog in
Avatar of verpit
verpitFlag for United States of America

asked on

Limitations of Access 2003 .mdb file extension?

I use Access 2007 and love it.  When I need help with something, I would prefer to upload an .mdb file that more folks are going to be able to open.  Are there any specific limitations of the file format itself?

Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

what do you mean by .mdb limitations ?

.mdb can not utilize the functionalities available in .accdb
Avatar of verpit

ASKER

I see.  There are interface differences and then like you say, there are 'functionality' differences.  I was wondering if there was an outline somewhere of what 'functions' won't work in .mdb format?
verpit,

I wouldn't go so far as to say the mdb format has "Limitations".
It's just that microsoft changed the format of Access database files to take advantage of the new features.
So any "limitations" only show up now because you can compare it to Access 2007.

All this means to you is that you need to be sure you do not include any "2007 only"
features in your database. (RichText Formatting, MultiValuedFields, AttachmentDataTypes, Report OnLoad code, ...ect

JeffCoachman
Avatar of verpit

ASKER

Thanks Jim,  Those are great links.  Have you found a 2007 vs 2003 limitation comparison somewhere?  I want to see what specifically has changed in terms of 'function' with respect to the format from v2003.

ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of verpit

ASKER

Not really.  If 2003 had one limit and 2007 had the same limit, I'm not concerned.  I am looking for a comparison of not "what's changed in 2007", but what "functions" of the .mdb format itself has been improved with the new 2007 format?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of verpit

ASKER

"The major change to this" accdb format "was the inclusion of the Attachments field (which isn't backwards compatible)."
"Except for the different database, PDF creating ability and Ribbons there is little that's changed from a developer's standpoint."

That's very helpful!