What if I keep my .mdb format instead of converting to .accbd?

[mls via AccessMonster.com]

I have Access 2007 on my machines and using .mdb format, which works pretty
well. So will there be a problem if I use that way. Is it mandatory to
convert to .accbd. I will not use the new features like multivalued field etc.


And If at all I decide to convert what is the best option:
1) To open the database and save as .accbd?
2) Create blank db in 2007 and import all table\queries\macros and modules?

What if I have to open my .accbd in .mdb format after conversion?

Can anyone share their thoughts?

Thanks in advance.

 

[Jeff Boyce]

If there's any possibility that you (or a user) will need to open the data
using a version prior to Access 2007, do not convert the .mdb to an .accdb
format. The older versions of Access won't be able to open the newer
format. That said, you could still use an Access 2007 or later version to
open it, then save it "back" to an earlier version, if absolutely critical.

I've used both approaches and haven't noticed a difference. Perhaps other
newsgroup readers can document some kink of difference.

If you are unlikely to need the newer features in Access 2007 (and soon, in
Access 2010), you can safely leave it be. You could always convert at so
future date, right?


Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Tony Toews [MVP]]

I have Access 2007 on my machines and using .mdb format, which works pretty
well. So will there be a problem if I use that way. Is it mandatory to
convert to .accbd. I will not use the new features like multivalued field etc.

No, it is not mandatory to convert. If there is no need for the new
features then don't worry about it.

Besides, as Jeff states, you can convert later if required.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[mls via AccessMonster.com]

Thank you Jeff and Tony. That helps a lot.

No, it is not mandatory to convert. If there is no need for the new
features then don't worry about it.

Besides, as Jeff states, you can convert later if required.

Tony