By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,395 Members | 1,396 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,395 IT Pros & Developers. It's quick & easy.

Access Format

P: n/a
Is there a way to make an access db only open in say access 2002 and
up?

Sep 12 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Hi.
Is there a way to make an access db only open in say access 2002 and
up?
Yes. Create an MDB file in Access 2002 database format, and then create an
MDE file from it in Access 2002. Only Access 2002, 2003 and 2007 will be
able to open the database file. Earlier versions of Access will get an
error, "Unrecognized database format," when trying to open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
Sep 12 '07 #2

P: n/a
On Wed, 12 Sep 2007 22:06:04 GMT, "'69 Camaro"
<Fo**************************@Spameater.orgZERO_SP AMwrote:

Another way is to check the version of Access (better: Jet):
if dbengine.version <= 10 then
msgbox "No way!
end
end if

-Tom.

>Hi.
>Is there a way to make an access db only open in say access 2002 and
up?

Yes. Create an MDB file in Access 2002 database format, and then create an
MDE file from it in Access 2002. Only Access 2002, 2003 and 2007 will be
able to open the database file. Earlier versions of Access will get an
error, "Unrecognized database format," when trying to open the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
Sep 13 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.